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-26T10:52:40Z
Lists: pgsql-hackers 
On 2026-Feb-25, Álvaro Herrera wrote:

> On 2026-Feb-25, Álvaro Herrera wrote:
> 
> > 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.
> 
> Here it is.

Pushed.  I also added a test for the standard case of NO INHERIT in a
not-null constraint.

Thanks for reporting this.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Oh, great altar of passive entertainment, bestow upon me thy discordant images
at such speed as to render linear thought impossible" (Calvin a la TV)

Commits

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

  2. Dump not-null constraints on inherited columns correctly