BUG #19455: ALTER TABLE RENAME will rename a sequence - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #19455: ALTER TABLE RENAME will rename a sequence
Date
Msg-id 19455-8dabf39f306c3ccc@postgresql.org
Whole thread
Responses Re: BUG #19455: ALTER TABLE RENAME will rename a sequence
Re: BUG #19455: ALTER TABLE RENAME will rename a sequence
List pgsql-bugs
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)





pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #19454: PL/pgSQL mishandling jsonb attribute reference
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #19454: PL/pgSQL mishandling jsonb attribute reference