transaction commit

[Garry Saddington]

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?
Thanks
Garry

[Federico Di Gregorio]

Post by Garry Saddington
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

[Garry Saddington]

Post by Federico Di Gregorio

Post by Garry Saddington
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