Re: Make PG's "NOT NULL"s and attnotnull ("is_nullable") conform to SQL-2011 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Make PG's "NOT NULL"s and attnotnull ("is_nullable") conform to SQL-2011
Date
Msg-id 6616.1462373910@sss.pgh.pa.us
Whole thread Raw
In response to Re: Make PG's "NOT NULL"s and attnotnull ("is_nullable") conform to SQL-2011  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> This is a bit hard to reason about given that our implementation of
> inheritance is non-standard.

Yeah, that's a fairly key point.  We've solved those problems with
respect to inherited CHECK constraints, and it seems like what we
ought to do with NOT NULL is make it work the same as CHECK, rather
than invent some new concepts.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] Breakage with VACUUM ANALYSE + partitions
Next
From: Teodor Sigaev
Date:
Subject: Re: tsvector filter problem