dump/reload with sequences fails

PostgreSQL Bugs List <pgsql-bugs@postgresql.org>

From: pgsql-bugs@postgresql.org
To: pgsql-bugs@postgresql.org
Date: 2000-09-27T00:22:09Z
Lists: pgsql-bugs
Vince (vev@hub.org) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
dump/reload with sequences fails

Long Description
dumping a table then reloading it on a new database fails if there are sequences involved because the sequence isn't created before the copy.
After the copy, the sequence's value isn't updated.


Sample Code


No file was uploaded with this report