Thread

1. Error with sequences, "sequence was re-created"

   Charles H. Woloszynski <chw@clearmetrix.com> — 2002-10-02T18:01:00Z

   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].
   
   INSERT 40369 1
   INSERT 40370 1
   INSERT 40371 1
   INSERT 40372 1
   INSERT 40373 1
   INSERT 40374 1
   psql:reduced.sql:1297: NOTICE:  seq_service.currval: sequence was re-created
   psql:reduced.sql:1297: ERROR:  seq_service.currval is not yet defined in
   this session
   psql:reduced.sql:1299: ERROR:  seq_service.currval is not yet defined in
   this session
   psql:reduced.sql:1301: ERROR:  seq_service.currval is not yet defined in
   this session
   psql:reduced.sql:1303: ERROR:  seq_service.currval is not yet defined in
   this session
   psql:reduced.sql:1305: ERROR:  seq_service.currval is not yet defined in
   this session
   psql:
   
   
   What is causing the sequences to be re-created?  Is this a known issue?
   I have searched the archives but was unable to find more than a single
   message about this (and it did not discuss a resolution).
   
   I am using RH 7.2 and PostgreSQL 7.2.2.
   
   Any and all help is greatly appreciated.
   
   Charlie
   
   
   -- 
   
   
   Charles H. Woloszynski
   
   ClearMetrix, Inc.
   115 Research Drive
   Bethlehem, PA 18015
   
   tel: 610-419-2210 x400
   fax: 240-371-3256
   web: www.clearmetrix.com
   
   
   
   
   
   
   

2. Re: Error with sequences, "sequence was re-created"

   Stephan Szabo <sszabo@megazone23.bigpanda.com> — 2002-10-02T19:36:06Z

   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?