Re: Not Null Constraint vs Query Planning

2020-03-02 Thread Vik Fearing
On 03/03/2020 00:02, Don Seiler wrote: > On Mon, Mar 2, 2020, 12:30 Vik Fearing wrote: > >> On 02/03/2020 18:09, Don Seiler wrote: >>> The REAL reason for this is that I'm wondering if I created a NOT NULL >>> check constraint with "NOT VALID" would that then NOT be considered in >> such >>> a "s

Re: Not Null Constraint vs Query Planning

2020-03-02 Thread Don Seiler
On Mon, Mar 2, 2020, 12:30 Vik Fearing wrote: > On 02/03/2020 18:09, Don Seiler wrote: > > The REAL reason for this is that I'm wondering if I created a NOT NULL > > check constraint with "NOT VALID" would that then NOT be considered in > such > > a "short-circuit" case until I ran the VALIDATE C

Re: Not Null Constraint vs Query Planning

2020-03-02 Thread Vik Fearing
On 02/03/2020 18:09, Don Seiler wrote: > The REAL reason for this is that I'm wondering if I created a NOT NULL > check constraint with "NOT VALID" would that then NOT be considered in such > a "short-circuit" case until I ran the VALIDATE CONSTRAINT on it? Perhaps I > should have just asked this i