BUG #19455: ALTER TABLE RENAME will rename a sequence
| От | PG Bug reporting form |
|---|---|
| Тема | BUG #19455: ALTER TABLE RENAME will rename a sequence |
| Дата | |
| Msg-id | 19455-8dabf39f306c3ccc@postgresql.org обсуждение |
| Ответы |
Re: BUG #19455: ALTER TABLE RENAME will rename a sequence
Re: BUG #19455: ALTER TABLE RENAME will rename a sequence |
| Список | 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 по дате отправления: