Skip site navigation (1) Skip section navigation (2)

BUG #3619: Renaming sequence does not update its 'sequence_name' field

From: "Guillaume 'ioguix' de Rorthais" <ioguix(at)free(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3619: Renaming sequence does not update its 'sequence_name' field
Date: 2007-09-19 18:19:13
Message-ID: 200709191819.l8JIJDDJ001268@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3619
Logged by:          Guillaume 'ioguix' de Rorthais
Email address:      ioguix(at)free(dot)fr
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

Responses

pgsql-bugs by date

Next:From: mirekDate: 2007-09-19 19:59:37
Subject: BUG #3620: superuser password in windows registry
Previous:From: C├ędric VillemainDate: 2007-09-19 08:29:40
Subject: Re: CREATE USER and createuser not working the same

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group