Fix propagation of persistence to sequences in ALTER TABLE / ADD COLUMN

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Fix propagation of persistence to sequences in ALTER TABLE / ADD COLUMN
Date: 2024-02-05 15:51:05
Message-ID: c4b6e2ed-bcdf-4ea7-965f-e49761094827@eisentraut.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Commit 344d62fb9a9 (2022) introduced unlogged sequences and made it so
that identity/serial sequences automatically get the persistence level
of their owning table. But this works only for CREATE TABLE and not for
ALTER TABLE / ADD COLUMN. This patch fixes that. (should be
backpatched to 15, 16)

Attachment Content-Type Size
0001-Fix-propagation-of-persistence-to-sequences-in-ALTER.patch text/plain 3.8 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2024-02-05 15:56:23 Re: Patch: Add parse_type Function
Previous Message Tom Lane 2024-02-05 15:49:07 Re: Improve pg_trigger.tgargs representation