Re: Rename sequence bug/feature

Dave Page <dpage@vale-housing.co.uk> writes:
> I noticed in a post recently that it was possible to rename objects other
> than tables in pg_class using ALTER TABLE RENAME. I've now implemented this
> in pgAdmin II for views, sequences and indexes.

> Today I've had cause to dump my test database and found a minor problem:

> dumping database "helpdesk"...
> pg_dump: query to get data of sequence "cat" returned name "dog"

Well, we could either add code to ALTER RENAME to hack the sequence
name stored in sequences, or we could remove that check from pg_dump.
I kinda lean to the latter myself; it seems pretty useless.
        regards, tom lane