| 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)
| 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 |