Re: [HACKERS] foreign table creation and NOT VALID check constraints - Mailing list pgsql-hackers

From Amit Langote
Subject Re: [HACKERS] foreign table creation and NOT VALID check constraints
Date
Msg-id d49692e8-3ef3-4a4a-0550-7e36109670de@lab.ntt.co.jp
Whole thread Raw
In response to Re: [HACKERS] foreign table creation and NOT VALID check constraints  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] foreign table creation and NOT VALID check constraints  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 2017/08/02 20:40, Robert Haas wrote:
> On Wed, Aug 2, 2017 at 3:46 AM, Ashutosh Bapat
> <ashutosh.bapat@enterprisedb.com> wrote:
>> If the user has specified "not valid" for a constraint on the foreign
>> table, there is high chance that s/he is aware of the fact that the
>> remote table that the foreign table points to has some rows which will
>> violet the constraint. So, +1.
> 
> +1 from me, too.

Alright, thanks.

Attached is a patch.  I think this could be considered a bug-fix,
backpatchable to 9.6 which introduced this behavior change [1].

Thoughts?

Thanks,
Amit

[1]
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=f27a6b15e656

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Why does logical replication launcher exit with exitcode 1?
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Why does logical replication launcher exit with exitcode 1?