Re: persevere NO INHERIT when Dump not-null constraints on inherited columns

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: persevere NO INHERIT when Dump not-null constraints on inherited columns
Date: 2026-02-25 17:47:28
Message-ID: 202602251745.ux2ihjfq66s5@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bertrand Drouvot 2026-02-25 17:49:21 Re: Make use of unvolatize() in vac_truncate_clog()
Previous Message Srirama Kucherlapati 2026-02-25 17:41:44 RE: AIX support