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"
pg_dump failed on helpdesk, exiting
This can be recreated easily:
helpdesk=# create sequence dog;
helpdesk=# alter table dog rename to cat;
helpdesk=# select sequence_name from cat;
(now wondering how many responses will say it is a bug and how many will say
a sequence is not a table and I shouldn't be doing that anyway :) )
pgsql-hackers by date
|Next:||From: Colin Faber||Date: 2002-02-26 20:40:21|
|Subject: Re: PostgreSQL 8.0 ??|
|Previous:||From: Zak Greant||Date: 2002-02-26 20:30:41|
|Subject: eWeek Poll: Which database is most critical to your organization?|