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 ODBC Driver.

Ryan

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Wednesday, November 07, 2001 12:30 PM
> To: Mike Miller
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] ODBC & Transactions?
>
>
> "Mike Miller" <mmiller(at)pooka(dot)otago(dot)ac(dot)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(at)postgresql(dot)org)
>