Re: Re: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem. - Mailing list pgsql-bugs

From Srinath Reddy Sadipiralla
Subject Re: Re: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem.
Date
Msg-id CAFC+b6o75trAiX95J3GnX-UaAD+MiPvRdGDYy7P=npDQr5sUbw@mail.gmail.com
Whole thread Raw
In response to Re: Re: Re: BUG #19351: in pg18.1,when not null exists in the table , and add constraint problem.  (Álvaro Herrera <alvherre@kurilemu.de>)
List pgsql-bugs

Hi Álvaro,

On Sat, Dec 13, 2025 at 6:14 PM Álvaro Herrera <alvherre@kurilemu.de> wrote:

Yeah, that's fair -- we discussed this kind of behavior during
development and I was unsure about being strict about it, so avoided it.


+1 ,  thanks for the patch. 

This is mostly straightforward to fix, as attached (though the error
message needs work),
 
I have reviewed the patch except the below things and
LGTM until now.
 
but I hit a snag with multiple inheritance -- if
you apply this patch, you'll see failures in the pg_dump and pg_upgrade
tests.  I don't have any ideas to fix this right now, but I'll keep
thinking about it.
 
I need to look further into these parts,and will update once
I have something solid. 

--
Thanks,
Srinath Reddy Sadipiralla
EDB: https://www.enterprisedb.com/

pgsql-bugs by date:

Previous
From: T iv
Date:
Subject: Cluster is not being created
Next
From: "Haowu Ge"
Date:
Subject: Re: GROUP BY ROLLUP queries on views trigger full table scans (index usage not optimized)