Re: ODBC & Transactions? - Mailing list pgsql-odbc

From Ryan C. Bonham
Subject Re: ODBC & Transactions?
Date
Msg-id 19AB8F9FA07FB0409732402B4817D75A12513C@FILESERVER.SRF.srfarms.com
Whole thread Raw
In response to ODBC & Transactions?  ("Mike Miller" <mmiller@pooka.otago.ac.nz>)
Responses Re: ODBC & Transactions?
List pgsql-odbc
Hi,

I think the feature Tom is referring to is called "Use Declare/Fetch" and can be found under Advanced Options for the
ODBCDriver. 

Ryan

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Wednesday, November 07, 2001 12:30 PM
> To: Mike Miller
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] ODBC & Transactions?
>
>
> "Mike Miller" <mmiller@pooka.otago.ac.nz> writes:
> > If I execute the SQL statements using ADO in VB6:
>
> > begin work
> > update mytable set myfield='changed-data' where myid = 1
> > rollback work
>
> > and then I check the database using psql on the server box,
> myfield =
> > 'changed-data'; and the rollback did *not* work.
>
> > In the postgres log appears:
> > NOTICE:  ROLLBACK: no transaction in progress
>
> This strongly suggests that ODBC is emitting its own "begin" and
> "commit" commands around each query that you give.  I am not an ODBC
> person but I think that this misfeature is called autocommit and that
> you can turn it off.
>
> If you want to know what's really going on, try enabling query logging
> at the postmaster, then look in the postmaster's log output
> to see what
> queries are really getting sent by ODBC.
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>

pgsql-odbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: ODBC & Transactions?
Next
From: patriq@gmx.de
Date:
Subject: application terminates on post