unnecessary auto-transaction-rollback from driver - part 1 of 2

From: Hartmut Raschick <hartmut(dot)raschick(at)ke-elektronik(dot)de>
To: "postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: unnecessary auto-transaction-rollback from driver - part 1 of 2
Date: 2003-08-29 07:01:06
Message-ID: 3F4EFA32.5F9CB5DC@ke-elektronik.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

next try, I hope this time the message is not too big for
poor pgsql-odbc(at)postgres(dot)org(dot)(dot)(dot)(dot)

PLEASE MIND part 2 (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.: You can tune a guitar, but you can't tune a fish.
- Tom Robbins

--
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(dot)raschick(at)ke-elektronik(dot)de
http://www.ke-elektronik.de

Attachment Content-Type Size
psqlodbc-07.03.0100-auto-rollback-part1of2.tar.gz application/x-gzip 12.4 KB

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Richard Huxton 2003-08-29 10:00:50 Re: help
Previous Message Hartmut Raschick 2003-08-29 06:50:38 unnecessary auto-transaction-rollback from driver - part 2 of 2