The following bug has been logged on the website:
Bug reference: 19455
Logged by: Bob Sislow
Email address: bsislow@accertify.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)