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@sss.pgh.pa.us> wrote:
> "Evgeny Gridasov" <eugrid@fpm.kubsu.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