Re: transaction commit

Federico Di Gregorio wrote:
> On 03/09/2010 18:10, Garry Saddington wrote:
>> We are using the Psycopg2 DA for zope. Is there a way to force auto
>> commit on a transaction or does the use of COMMIT in a ZSQL method have
>> the desired effect?
> 
> Not easily. Also, I won't do that. Zope uses its own transaction tied to
> "page execution" and trying to do something different is like opening a
> can of worms.
> 
> federico
Thanks but we are having real problems on Windows server with 
Zope/Psycopg/Postgresql. The data is being sent by zope but it's not 
getting committed to the database and in some cases is just 
disappearing, and to make it worse this is an intermittant fault. We 
have Postgres logging to the event viewer and when this occurs there is 
no Postgres log of the transaction so we have no idea what is going on.

Can anyone suggest how we could debug this scenario?
Thanks
Garry