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

From Günce Kaya
Subject Re: [ADMIN] Postgresql FDW - some difference between remote andtarget table structure
Date
Msg-id CAAV2-mU5iCeebXjfUSzu4PmzgmL6YmyHXCoQVXaQ8yWSCzj=mQ@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Postgresql FDW - some difference between remote and target table structure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hello Tom,

I appreciate to your response. It’s clear now to me. 

Regards,
Gunce 


On 5 Oct 2017 Thu at 16:55 Tom Lane <tgl@sss.pgh.pa.us> wrote:
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
--
Gunce Kaya

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] Postgresql FDW - some difference between remote and target table structure
Next
From: Simon Major
Date:
Subject: [ADMIN] Additional checks for orphaned files