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