> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 27 February 2002 05:20
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] 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.
That could potentially break any user apps that (for whatever bizarre
reason) do a select sequence_name of course, though I can't imagine why
anyone would do that. pgAdmin certainly doesn't.
Either fix would be fine for me though...
Thanks, Dave.