Re: Rename sequence bug/feature - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Rename sequence bug/feature
Date
Msg-id 19873.1014787177@sss.pgh.pa.us
Whole thread Raw
In response to Rename sequence bug/feature  (Dave Page <dpage@vale-housing.co.uk>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Refactoring of command.c
Next
From: Bruce Momjian
Date:
Subject: Renaming files