Re: Rename sequence bug/feature

> -----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.