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?