What is the correct way to rename a sequence?
I keep running into this bug:
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.
pgsql-general by date
|Next:||From: Mark Neely||Date: 2008-05-27 02:18:57|
|Subject: Open Source CRM - Options?|
|Previous:||From: Tom Lane||Date: 2008-05-27 00:36:10|
|Subject: Re: select query takes 13 seconds to run with index |