Re: pg_dump: assert failure sorting casts/transforms - Mailing list pgsql-hackers

From Alexander Kukushkin
Subject Re: pg_dump: assert failure sorting casts/transforms
Date
Msg-id CAFh8B=kyXjy=1NzACXsD7LFS3rfAsWmpdXbWDs5f4=1C8uG8pw@mail.gmail.com
Whole thread
List pgsql-hackers
Hi Noah,

sorry that it took so long to get back.

On Wed, 9 Sept 2026 at 02:04, Noah Misch <noah@leadboat.com> wrote:
Since this is already the fourth follow-up to my original change, I had Opus 5
look for more ways to reach the assertion.  It found one more:

D1  DO_POLICY: the "RLS enabled" pseudo-object borrows its table's relname, so
    it ties with a policy named after that same table.  An assert-enabled
    pg_dump aborts; a production build orders the two by comparing a pg_class
    OID against a pg_policy OID, which pg_upgrade inverts.

Let's fix that at the same time.  Would you like to add that, or would you
like me to add it?

Please find the attached v4 version of the patch that also handles RLS policies.

--
Regards,
--
Alexander Kukushkin
Attachment

pgsql-hackers by date:

Previous
From: Alexandre Felipe
Date:
Subject: Re: Throwing away unnecessary spin-locks
Next
From: Laurenz Albe
Date:
Subject: Re: Adding a stored generated column without long-lived locks