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-25T18:23:20Z

Lists: pgsql-hackers

Attachments

v2-0001-Fix-pg_dump-for-NO-INHERIT-constraints-on-inherit.patch (text/x-diff)

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.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/

Commits

pg_dump: Preserve NO INHERIT on NOT NULL on inheritance children
- d0833fdae7eb 19 (unreleased) landed
- c3c8b63d76be 18.4 landed
Dump not-null constraints on inherited columns correctly
- fd41ba93e463 18.0 cited