BUG #19455: ALTER TABLE RENAME will rename a sequence

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: bsislow(at)accertify(dot)com
Subject: BUG #19455: ALTER TABLE RENAME will rename a sequence
Date: 2026-04-13 12:48:35
Message-ID: 19455-8dabf39f306c3ccc@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 19455
Logged by: Bob Sislow
Email address: bsislow(at)accertify(dot)com
PostgreSQL version: 15.2
Operating system: Red Hat Enterprise Linux release 8.7 (Ootpa)
Description:

Is this expected behavior? ALTER TABLE RENAME will rename a sequence.

postgres=# create sequence test;
CREATE SEQUENCE
postgres=# \ds
List of relations
Schema | Name | Type | Owner
----------+------+----------+----------
dbaadmin | test | sequence | postgres
(1 row)

postgres=# alter table test rename to test2;
ALTER TABLE
postgres=# \ds
List of relations
Schema | Name | Type | Owner
----------+-------+----------+----------
dbaadmin | test2 | sequence | postgres
(1 row)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2026-04-13 14:10:29 Re: BUG #19454: PL/pgSQL mishandling jsonb attribute reference
Previous Message PG Bug reporting form 2026-04-12 15:45:39 BUG #19454: PL/pgSQL mishandling jsonb attribute reference