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 по дате отправления: