Re: transaction bug with sequences ?

From: xoror(at)infuse(dot)org
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: transaction bug with sequences ?
Date: 2002-03-14 11:51:12
Message-ID: Pine.GSO.4.10.10203141247400.1018-100000@aries
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


damn, the sequence in transactions is now also giving me problems in
pgsql. so this might be a pgsql bug (?) afterall ? or dit i miss something
here...

BEGIN TRANSACTION;
select nextval('some_id_seq');
ROLLBACK;

BEGIN TRANSACTION;
select nextval('some_id_seq');
ROLLBACK;

BEGIN TRANSACTION;
select nextval('some_id_seq');
ROLLBACK;

BEGIN TRANSACTION;
select nextval('some_id_seq');
ROLLBACK;

the sequence value is incremented, but this shouldn't be the case because
i cancelled the transaction.

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Tom Lane 2002-03-14 15:46:13 Re: transaction bug with sequences ?
Previous Message xoror 2002-03-14 11:42:47 transaction bug with sequences ?