dump/reload with sequences fails

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: dump/reload with sequences fails
Date: 2000-09-27 00:22:09
Message-ID: 200009270022.e8R0M9u64780@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Vince (vev(at)hub(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2000-09-27 11:29:26 Documentation bug
Previous Message Tom Lane 2000-09-26 20:58:00 Re: Can't compile postgres 7 on HP-UX 10.2