Re: CREATE TABLE NOT VALID for check and foreign key

On 2025-Jan-08, Alvaro Herrera wrote:

> On 2025-Jan-07, Yasuo Honda wrote:
>
> > I'd like PostgreSQL to raise errors and/or warnings for the NOT VALID
> > check constraint for CREATE TABLE.
> > Ruby on Rails supports creating check constraints with the NOT VALID
> > option and I was not aware that it is just ignored until
> > https://github.com/rails/rails/issues/53732 issue is reported.
>
> Thanks. I left a comment there. I think raising a WARNING might work.

I think it'd be something like the rough POC here. I didn't add
warnings to all the CreateConstraintEntry() because some of them aren't
reachable via a path that allows NOT VALID. However, I may have missed
some cases.

I was really surprised to find that we have no test coverage for the
case where CREATE TABLE specifies a NOT VALID constraint.

--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/