Re: [ADMIN] Postgresql FDW - some difference between remote andtarget table structure

Поиск
Список
Период
Сортировка
От Günce Kaya
Тема Re: [ADMIN] Postgresql FDW - some difference between remote andtarget table structure
Дата
Msg-id CAAV2-mU5iCeebXjfUSzu4PmzgmL6YmyHXCoQVXaQ8yWSCzj=mQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Postgresql FDW - some difference between remote and target table structure  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [ADMIN] Postgresql FDW - some difference between remote and target table structure
Следующее
От: Simon Major
Дата:
Сообщение: [ADMIN] Additional checks for orphaned files