Thread: [GENERAL] FDW table doesn't exist
Hi all, I have a FDW to another database but I started getting this error while trying to use it select * from aut_class limit 10; ERROR: column "acceptance_threshhold" does not exist HINT: Perhaps you meant to reference the column "aut_class.acceptance_threshold". Yet when I do some checking, it's obvious that the column does exist. acceptance_threshhold | numeric | | (column_name 'acceptance_threshhold') | main | | Any ideas on what I can do to fix this or debug this problem? -- View this message in context: http://www.postgresql-archive.org/FDW-table-doesn-t-exist-tp5958279.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Figured this out... someone changed the name of the column and took out the extra 'h' in acceptance_threshhold on the database the fdw is pointing.... -- View this message in context: http://www.postgresql-archive.org/FDW-table-doesn-t-exist-tp5958279p5958336.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.