unnecessary auto-transaction-rollback from driver - part 2 of 2 - Mailing list pgsql-odbc

From Hartmut Raschick
Subject unnecessary auto-transaction-rollback from driver - part 2 of 2
Date
Msg-id 3F4EF7BE.198B178D@ke-elektronik.de
Whole thread Raw
List pgsql-odbc
PLEASE MIND part 1 (another mail)

driver: psqlodbc-07.03.0100
postgres: 7.3.2
error messages: n/a
mylog: mylog_raschick10724.log
commlog(psqlodbc_????.log): psqlodbc_raschick10724.log
ODBC trace log (sql.log): n/a

when issuing (w/i a transaction) a faulty request (in this case: attempt to
set a column that does not exist) the driver will auto-rollback (see logs).
however, as the program has started the transaction, it will try to rollback
itself. this will fail. (you see this twice in the logs - dont worry, one is
destructor clean-up...)
IMHO, the driver should not do a rollback here.
while inspecting the sources, i found that it actually knows about being in
a trx (succesful "BEGIN" command), why it would not use this info, i dont
know...

P.S.:
--
Hartmut "Hardy" Raschick / Dept. t2
ke Kommunikations-Elektronik GmbH
Wohlenberstr. 3, 30179 Hannover
Phone: ++49 (0)511 6747-564
Fax: ++49 (0)511 6747-340
e-Mail: hartmut.raschick@ke-elektronik.de
http://www.ke-elektronik.de

Attachment

pgsql-odbc by date:

Previous
From: Hartmut Raschick
Date:
Subject: unnecessary auto-transaction-rollback from driver - part 1 of 2
Next
From: Franco Violi
Date:
Subject: Some corrections on psqlodbc driver