| From: | Jonathan Vanasco <postgres(at)2xlp(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | renaming sequences ? |
| Date: | 2008-05-27 01:34:21 |
| Message-ID: | 214BDF44-6FA8-421F-9700-59C0F70126C2@2xlp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
What is the correct way to rename a sequence?
I keep running into this bug:
http://archives.postgresql.org/pgsql-bugs/2007-09/msg00092.php
Where "ALTER TABLE/SEQUENCE RENAME TO ____" will rename the sequence,
but the 'sequence_name' attribute in 'select * from sequence' and (i
believe) the pg catalog info will keep the original name
this creates an issue with most ORM software under python, perl, php
which will pull the old sequence name.
the 'fix' i found is to just dump , drop, create and reload the
database -- which works perfect on small databases. but i'm left
wondering what the correct fix is for medium/larger databases.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Neely | 2008-05-27 02:18:57 | Open Source CRM - Options? |
| Previous Message | Tom Lane | 2008-05-27 00:36:10 | Re: select query takes 13 seconds to run with index |