| 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: | 19873.1014787177@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Hirsch | 2002-02-27 05:28:09 | Re: eWeek Poll: Which database is most critical to your |
| Previous Message | Tom Lane | 2002-02-27 05:03:17 | Re: Refactoring of command.c |