Re: Postgresql FDW - some difference between remote and target table structure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Günce Kaya <guncekaya14(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgresql FDW - some difference between remote and target table structure
Date: 2017-10-05 13:55:35
Message-ID: 28776.1507211735@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

=?UTF-8?Q?G=C3=BCnce_Kaya?= <guncekaya14(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Günce Kaya 2017-10-05 14:19:45 Re: Postgresql FDW - some difference between remote and target table structure
Previous Message Günce Kaya 2017-10-05 10:44:59 Postgresql FDW - some difference between remote and target table structure