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 |
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 |