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
"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
The following bug has been logged online:
Bug reference: 2588
Logged by: Evgeny Gridasov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4-cvs
Operating system: linux debian
Description:rename table and dump bug
Details:
test=# create table tseq1(id serial)
