Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw
Дата
Msg-id 5AA63257.5010805@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Ответы Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Список pgsql-hackers
(2018/03/09 20:55), Etsuro Fujita wrote:
> (2018/03/08 14:24), Ashutosh Bapat wrote:
>> For local constraints to be enforced, we use remote
>> constraints. For local WCO we need to use remote WCO. That means we
>> create many foreign tables pointing to same local table on the foreign
>> server through many views, but it's not impossible.
>
> Maybe I don't understand this correctly, but I guess that it would be
> the user's responsibility to not create foreign tables in such a way.

I think I misunderstood your words.  Sorry for that.  I think what you 
proposed would be a solution for this issue, but I'm not sure that's a 
good one because that wouldn't work for the data sources that don't 
support views with WCO options.

Best regards,
Etsuro Fujita


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: PATCH: Configurable file mode mask
Следующее
От: Jeevan Ladhe
Дата:
Сообщение: Fix error in ECPG while connection handling