Re: Error with sequences, "sequence was re-created"
Stephan Szabo <sszabo@megazone23.bigpanda.com>
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: "Charles H. Woloszynski" <chw@clearmetrix.com>
Cc: <pgsql-general@postgresql.org>
Date: 2002-10-02T19:36:06Z
Lists: pgsql-general
On Wed, 2 Oct 2002, Charles H. Woloszynski wrote: > I am porting an existing database to PostgreSQL and have encountered a > strange error. > > When I am in psql and use \i to read the SQL script, I get messages > about various sequences being re-created. After the re-creation of > the sequence, I am getting errors about currval() not being valid. I've > included a snippet of the output below. [There were a series of ERROR > messages that the script causes when it tries to drop tables that don't > exist ... I've ignored those... perhaps to my detriment]. Can you send the appropriate section of the script?