Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Justin Pryzby <pryzby(at)telsasoft(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, Ali Akbar <the(dot)apaan(at)gmail(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org, rmt(at)lists(dot)postgresql(dot)org
Subject: Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL
Date: 2025-07-05 08:07:46
Message-ID: 202507050807.vqslmohdgjga@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2025-Jul-04, Tom Lane wrote:

> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> > On 2025-Jul-04, Alvaro Herrera wrote:
> >> Hmm, crake doesn't like the fact that there's no regnamespace in 9.4.
> >> Apparently in version 13 we claim to support back to 9.0. I only tried
> >> with an old server version 12. Should be an easy fix ...
>
> > It goes like this. It's tested with 9.2 only though, as 9.1 doesn't
> > compile from Git (lack of Flex) and I didn't want to try a tarball.
>
> Query works, or at least throws no error, back to 8.4 (the oldest I
> have at hand).

Thanks for checking! Pushed late yesterday, crake is happy now.

--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"Ninguna manada de bestias tiene una voz tan horrible como la humana" (Orual)

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Dilip Kumar 2025-07-05 08:56:26 Re: Conflict detection for update_deleted in logical replication
Previous Message Vik Fearing 2025-07-05 07:32:24 Re: array_random