The following bug has been logged on the website:
Bug reference: 7920
Logged by: Maksym Boguk
Email address: maxim(dot)boguk(at)gmail(dot)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]=# create sequence qqq;
[postgres]=# SELECT sequence_name FROM qqq;
sequence_name
---------------
qqq
[postgres]=# alter sequence qqq rename to lalala;
--surprise [postgres]=# SELECT sequence_name
FROM lalala;
sequence_name
---------------
qqq
pg_dump -F p -s postgres | grep qqq
--empty