I am confused by this bug report. Please show us the CREATE TABLE that goes with it.
--------------------------------------------------------------------------- Guillaume 'ioguix' de Rorthais wrote: > > The following bug has been logged online: > > Bug reference: 3619 > Logged by: Guillaume 'ioguix' de Rorthais > Email address: [EMAIL PROTECTED] > PostgreSQL version: all - cvs > Operating system: Linux > Description: Renaming sequence does not update its 'sequence_name' > field > Details: > > When renaming a sequence, using ALTER SEQUENCE in pg8.3 or ALTER TABLE for > pg < 8.3, its sequence_name field is not updated. > > Here is how to produce this bug (output from psql 8.3devel): > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > pagila=# select sequence_name from actor_actor_id_seq_renamed; > sequence_name > -------------------- > actor_actor_id_seq > (1 row) > pagila=# ALTER SEQUENCE actor_actor_id_seq RENAME TO > actor_actor_id_seq_renamed; > ALTER SEQUENCE > pagila=# select sequence_name from actor_actor_id_seq_renamed; > sequence_name > -------------------- > actor_actor_id_seq > (1 row) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > I guess the latest request should output actor_actor_id_seq_renamed, > shouldn't it ? > > -- > ioguix > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
