Re: Error with sequences, "sequence was re-created" - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Error with sequences, "sequence was re-created"
Date
Msg-id 20021002123528.J10839-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Error with sequences, "sequence was re-created"  ("Charles H. Woloszynski" <chw@clearmetrix.com>)
List 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?



pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Question about Cursors
Next
From: "Mihai Gheorghiu"
Date:
Subject: Use of GROUP BY