Re: [GENERAL] FDW table doesn't exist

[kerneltrick]

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.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] FDW table doesn't exist

[kerneltrick]

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.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general