FDW table doesn't exist

From: kerneltrick <brian(dot)pontz(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: FDW table doesn't exist
Date: 2017-04-25 15:39:39
Message-ID: 1493134779815-5958279.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Claudio Freire 2017-04-25 16:07:41 Re: Questionaire: Common WAL write rates on busy servers.
Previous Message Adrian Klaver 2017-04-25 15:18:18 Re: Failed dependencies for Pgadmin4 Web in Centos 7