Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw
Date
Msg-id 5AA63257.5010805@lab.ntt.co.jp
Whole thread Raw
In response to Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw  (Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>)
Responses Re: [HACKERS] Another oddity in handling of WCO constraints in postgres_fdw  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List 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 by date:

Previous
From: Michael Paquier
Date:
Subject: Re: PATCH: Configurable file mode mask
Next
From: Jeevan Ladhe
Date:
Subject: Fix error in ECPG while connection handling