Horton

Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Suraj Kharage <suraj.kharage@enterprisedb.com>
Cc: jian he <jian.universality@gmail.com>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2025-03-05T12:56:30Z
Lists: pgsql-hackers 
On 2025-Mar-03, Suraj Kharage wrote:

> Thanks Alvaro for the review and fixup patch.
> 
> I agree with your changes and merged that into the main patch along with a
> couple of other changes.
> 
> Please find attached v6 for further review.

Thanks, I have pushed this.  I made some changes to the tests, first by
renaming the tables to avoid too generic names, and second to try and
exercise everything about once.

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

Commits

  1. Small fixes for Add ALTER TABLE ... ALTER CONSTRAINT ... SET [NO] INHERIT

  2. Add ALTER TABLE ... ALTER CONSTRAINT ... SET [NO] INHERIT

  3. Add pg_constraint rows for not-null constraints