Re: BUG #10526: bad sequence rename - Mailing list pgsql-bugs

gnuplanet@gmail.com writes:
> xxx=> create sequence a;
> CREATE SEQUENCE
> xxx=> alter sequence a rename to b;
> ALTER SEQUENCE
> xxx=> select sequence_name from b;
>  sequence_name
> ---------------
>  a
> (1 row)

This is not a bug; it's just how sequences work.

20-20 hindsight would suggest that the sequence name should never have
been included in the sequence data at all, but it's there and it will
always represent the original sequence name.

            regards, tom lane