Обсуждение: Error with sequences, "sequence was re-created"

Поиск
Список
Период
Сортировка

Error with sequences, "sequence was re-created"

От
"Charles H. Woloszynski"
Дата:
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

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

От
Stephan Szabo
Дата:
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?