Request a Demo
Home   >   mailing lists

Re: persevere NO INHERIT when Dump not-null constraints on inherited columns - Mailing list pgsql-hackers

From Álvaro Herrera
Subject Re: persevere NO INHERIT when Dump not-null constraints on inherited columns
Date
Msg-id 202602251745.ux2ihjfq66s5@alvherre.pgsql
Whole thread Raw
In response to persevere NO INHERIT when Dump not-null constraints on inherited columns  (jian he <jian.universality@gmail.com>)
Responses Re: persevere NO INHERIT when Dump not-null constraints on inherited columns
List pgsql-hackers
Tree view 
On 2026-Feb-25, jian he wrote:

> create table p1(f1 int);
> create table p1_c1() inherits(p1);
> alter table p1_c1 add constraint p1c1_a_nn not null f1 no inherit;

Ugh, you're right, this is broken and your patch fixes it.

I'm gonna write a quick test case for this and push as soon as I'm able.

-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"Hay quien adquiere la mala costumbre de ser infeliz" (M. A. Evans)

pgsql-hackers by date:

Previous
From: Srirama Kucherlapati
Date:
Subject: RE: AIX support
Next
From: Bertrand Drouvot
Date:
Subject: Re: Make use of unvolatize() in vac_truncate_clog()