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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx> wrote:
=?UTF-8?Q?G=C3=BCnce_Kaya?= <guncekaya14@xxxxxxxxx> 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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux