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

Re: BUG #2588: rename table and dump bug

From: Evgeny Gridasov <eugrid(at)fpm(dot)kubsu(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2588: rename table and dump bug
Date: 2006-08-25 13:38:06
Message-ID: 20060825173806.e4cdfd1c.eugrid@fpm.kubsu.ru (view raw or flat)
Thread:
Lists: pgsql-bugs
So why then when I rename a table, pg_dump prints out the renamed table and renamed sequence,
but the database has only table renamed and the original sequence??

The reason I'm asking this is because after some table renaming I've got:
in database: table1 with sequence1, table2 with sequence2
in a dump: table1 with sequence2, table2 with sequence1

On Fri, 25 Aug 2006 09:24:54 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "Evgeny Gridasov" <eugrid(at)fpm(dot)kubsu(dot)ru> writes:
> > Is it a pg_dump bug or 'ALTER TABLE xxx RENAME TO xxx'  does not rename the
> > corresponding sequences?
> 
> ALTER TABLE doesn't (and shouldn't IMHO) rename the sequence.  See
> http://archives.postgresql.org/pgsql-hackers/2006-08/msg01250.php
> 
> 			regards, tom lane
> 


-- 
Evgeny Gridasov
Software Engineer 
I-Free, Russia

In response to

pgsql-bugs by date

Next:From: Purusothaman ADate: 2006-08-26 10:17:32
Subject: BUG #2591: Failed to create process: 2!
Previous:From: Tom LaneDate: 2006-08-25 13:32:48
Subject: Re: BUG #2589: corrupt file

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