The following bug has been logged on the website:

Bug reference:      7920
Logged by:          Maksym Boguk
Email address:      maxim.bo...@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]=# 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




-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to