The following bug has been logged on the website:
Bug reference: 7920
Logged by: Maksym Boguk
Email address: maxim.boguk@gmail.com
PostgreSQL version: 9.2.3
Operating system: Linux
Description: =
sequence_name left stale after sequence rename:
Test case shows same problem on versions 9.0 9.1 9.2:
[postgres]=3D# create sequence qqq;
[postgres]=3D# SELECT sequence_name FROM qqq;
sequence_name
---------------
qqq
[postgres]=3D# alter sequence qqq rename to lalala;
--surprise [postgres]=3D# SELECT sequence_name
FROM lalala;
sequence_name
---------------
qqq
pg_dump -F p -s postgres | grep qqq
--empty