Re: cataloguing NOT NULL constraints - Mailing list pgsql-hackers

From Alexander Lakhin
Subject Re: cataloguing NOT NULL constraints
Date
Msg-id 045dec3f-9b3d-aa44-0c99-85f6992306c7@gmail.com
Whole thread Raw
In response to Re: cataloguing NOT NULL constraints  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: cataloguing NOT NULL constraints
List pgsql-hackers
Hello Alvaro,

Please look at an anomaly introduced with b0e96f311.
The following script:
CREATE TABLE a ();
CREATE TABLE b (i int) INHERITS (a);
CREATE TABLE c () INHERITS (a, b);

ALTER TABLE a ADD COLUMN i int NOT NULL;

results in:
NOTICE:  merging definition of column "i" for child "b"
NOTICE:  merging definition of column "i" for child "c"
ERROR:  tuple already updated by self

(This is similar to bug #18297, but ATExecAddColumn() isn't guilty in this
case.)

Best regards,
Alexander



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: XLog size reductions: smaller XLRec block header for PG17
Next
From: Robert Haas
Date:
Subject: Re: Commitfest 2024-01 is now closed