BUG #7920: Sequence rename leave stale value for sequence_name

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