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

From Amit Langote
Subject [HACKERS] foreign table creation and NOT VALID check constraints
Date
Msg-id d2b7419f-4a71-cf86-cc99-bfd0f359a1ea@lab.ntt.co.jp
Whole thread Raw
Responses Re: [HACKERS] foreign table creation and NOT VALID check constraints  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
In f27a6b15e656 (9.6 & later), we decided to "Mark CHECK constraints
declared NOT VALID valid if created with table."  In retrospect,
constraints on foreign tables should have been excluded from consideration
in that commit, because the thinking behind the aforementioned commit
(that the constraint is trivially validated because the newly created
table contains no data) does not equally apply to the foreign tables case.

Should we do something about that?

Thanks,
Amit




pgsql-hackers by date:

Previous
From: Victor Wagner
Date:
Subject: Re: [HACKERS] PostgreSQL 10 (latest beta) and older ICU
Next
From: Simon Riggs
Date:
Subject: Re: [HACKERS] foreign table creation and NOT VALID check constraints