Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Postgresql FDW - some difference between remote and target table structure - Mailing list pgsql-admin

From Tom Lane
Subject Re: [ADMIN] Postgresql FDW - some difference between remote and target table structure
Date
Msg-id 28776.1507211735@sss.pgh.pa.us
Whole thread Raw
In response to [ADMIN] Postgresql FDW - some difference between remote and target table structure  (Günce Kaya <guncekaya14@gmail.com>)
Responses Re: [ADMIN] Postgresql FDW - some difference between remote andtarget table structure  (Günce Kaya <guncekaya14@gmail.com>)
List pgsql-admin
Tree view 
Günce Kaya <guncekaya14@gmail.com> writes:
> Why there is some difference between FDW and target database? Is there
> anyone who can explain it?

Either the foreign table was created without that column to begin with,
or the column was added to the remote table later and the foreign table
wasn't updated to match.  Foreign tables don't magically track what is
on the remote server; they just have the set of columns you told the
local server they should have.
        regards, tom lane


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

pgsql-admin by date:

Previous
From: Günce Kaya
Date:
Subject: [ADMIN] Postgresql FDW - some difference between remote and target table structure
Next
From: Günce Kaya
Date:
Subject: Re: [ADMIN] Postgresql FDW - some difference between remote andtarget table structure