Skip site navigation (1) Skip section navigation (2)

Re: Rename sequence bug/feature

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Rename sequence bug/feature
Date: 2002-02-27 05:19:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Dave Page <dpage(at)vale-housing(dot)co(dot)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

In response to

pgsql-hackers by date

Next:From: Ken HirschDate: 2002-02-27 05:28:09
Subject: Re: eWeek Poll: Which database is most critical to your
Previous:From: Tom LaneDate: 2002-02-27 05:03:17
Subject: Re: Refactoring of command.c

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group