transaction bug with sequences ?

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