Skip site navigation (1) Skip section navigation (2)

transaction bug with sequences ?

From: xoror(at)infuse(dot)org
To: pgsql-odbc(at)postgresql(dot)org
Subject: transaction bug with sequences ?
Date: 2002-03-14 11:42:47
Message-ID: Pine.GSO.4.10.10203141234450.987-100000@aries (view raw or flat)
Thread:
Lists: pgsql-odbc
hi,

i've encountered some strange problem with ODBC  psqlodbc-07_01_0009
(system: pgsql 7.2 - cygwin)

this piece of SQL is giving me problems.


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 expected result (and the result i'm getting from psql commandline
tool) is 4 times an __identical__ result value. Now, if i use ODBC and
execute these series of queries, i get 4 __different__ values. i think
something's wrong with odbc or borland bde (wich i'm using). Hope someone
could clear this one up.


thnx in advance


Responses

pgsql-odbc by date

Next:From: xororDate: 2002-03-14 11:51:12
Subject: Re: transaction bug with sequences ?
Previous:From: Jean-Michel POUREDate: 2002-03-14 08:36:22
Subject: Re: ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group