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 <[EMAIL PROTECTED]> wrote: > "Evgeny Gridasov" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
