Re: unnecessary auto-transaction-rollback from driver - part 1 of

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Hartmut Raschick <hartmut(dot)raschick(at)ke-elektronik(dot)de>
Cc: "postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: unnecessary auto-transaction-rollback from driver - part 1 of
Date: 2003-09-01 09:50:03
Message-ID: 3F53164B.8E5D7523@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hartmut Raschick wrote:
>
> 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...)

Please don't execute "begin", "commit", "rollback" directly.
For example, please call SQLTransact to commit/rollback the
transaction.

regards,
Hiroshi Inoue
http://www.geocities.jp/inocchichichi/psqlodbc/

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Gary Faulkner 2003-09-01 14:30:37 psqlODBC Bug Report - Issue with Reverse Engineering PostgreSQL Database in Visio 2002
Previous Message Hiroshi Inoue 2003-09-01 09:37:48 Re: Some corrections on psqlodbc driver