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-26 10:52:40
Message-ID: 202602261051.gtzz7ua36rcs@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Junwang Zhao 2026-02-26 11:04:24 Re: guc: make dereference style consistent in check_backtrace_functions
Previous Message Jim Jones 2026-02-26 10:52:17 Re: Show comments in \dRp+, \dRs+, and \dX+ psql meta-commands