query_table SQL query has bad quotes

ncx-co / tidyFIA

Apache License 2.0

16 stars 2 forks source link

query_table SQL query has bad quotes #9

Closed hrodmn closed 3 years ago

hrodmn commented 3 years ago

tests produce this error:

Error (test-tidy_FIA.R:16:3): tidy_fia produces expected output when postgis = TRUE
Error: Failed to prepare query: ERROR:  relation "fiadb.fs_fiadb.subplot" does not exist
LINE 2: FROM "fiadb"."fs_fiadb.subplot" AS "q02"
             ^

hrodmn commented 3 years ago

This post has a clue about extra quotes included in a query causing issues: https://stackoverflow.com/questions/36753568/postgresql-tables-exists-but-getting-relation-does-not-exist-when-querying