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

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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: "Guillaume 'ioguix' de Rorthais" <ioguix(at)free(dot)fr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field
Date: 2007-09-26 10:27:55
Message-ID: 200709261027.l8QARt414174@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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:      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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>                http://archives.postgresql.org

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-bugs by date

Next:From: ioguixDate: 2007-09-26 11:52:47
Subject: Re: BUG #3619: Renaming sequence does not update its 'sequence_name' field
Previous:From: Teodor SigaevDate: 2007-09-26 10:19:49
Subject: Re: Crash 8.2.5 backend using tsearch2

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