Horton

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

Álvaro Herrera <alvherre@kurilemu.de>

View thread View on postgr.es
From: Álvaro Herrera <alvherre@kurilemu.de>
To: jian he <jian.universality@gmail.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2026-02-25T17:47:28Z
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)

Commits

  1. pg_dump: Preserve NO INHERIT on NOT NULL on inheritance children

  2. Dump not-null constraints on inherited columns correctly