Re: ODBC & Transactions?

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