From: Alexander Lakhin <exclusion@gmail.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Dean Rasheed <dean.a.rasheed@gmail.com>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Subject: Re: cataloguing NOT NULL constraints
Date: Thu, 31 Aug 2023 13:00:00 +0300
Message-ID: <d57b4a69-7394-3146-5976-9a1ef27e7972@gmail.com> (raw)
In-Reply-To: <20230825113833.4li4xnii2h4r3mqd@alvherre.pgsql>
References: <20230825113833.4li4xnii2h4r3mqd@alvherre.pgsql>
Hi Alvaro,
25.08.2023 14:38, Alvaro Herrera wrote:
> I have now pushed this again. Hopefully it'll stick this time.
I've found that after that commit the following query:
CREATE TABLE t(a int PRIMARY KEY) PARTITION BY RANGE (a);
CREATE TABLE tp1(a int);
ALTER TABLE t ATTACH PARTITION tp1 FOR VALUES FROM (0) to (1);
triggers a server crash:
Core was generated by `postgres: law regression [local] ALTER TABLE '.
Program terminated with signal SIGSEGV, Segmentation fault.
warning: Section `.reg-xstate/2194811' in core file too small.
#0 0x0000556007711d77 in MergeAttributesIntoExisting (child_rel=0x7fc30ba309d8,
parent_rel=0x7fc30ba33f18) at tablecmds.c:15771
15771 if (!((Form_pg_constraint) GETSTRUCT(contup))->connoinherit)
(gdb) bt
#0 0x0000556007711d77 in MergeAttributesIntoExisting (child_rel=0x7fc30ba309d8,
parent_rel=0x7fc30ba33f18) at tablecmds.c:15771
#1 0x00005560077118d4 in CreateInheritance (child_rel=0x7fc30ba309d8, parent_rel=0x7fc30ba33f18)
at tablecmds.c:15631
...
(gdb) print contup
$1 = (HeapTuple) 0x0
On b0e96f311~1 I get:
ERROR: column "a" in child table must be marked NOT NULL
Best regards,
Alexander
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: exclusion@gmail.com, alvherre@alvh.no-ip.org, dean.a.rasheed@gmail.com, peter@eisentraut.org, robertmhaas@gmail.com, pgsql-hackers@lists.postgresql.org
Subject: Re: cataloguing NOT NULL constraints
In-Reply-To: <d57b4a69-7394-3146-5976-9a1ef27e7972@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox