RE: [Zope-DB] Two actions in one ZSQL method = one transaction?

[Andreas Jung]

--On 14. Juni 2007 10:41:46 -0400 Ken Winter <[EMAIL PROTECTED]> wrote:

-----Original Message-----
From: Andreas Jung [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 14, 2007 12:54 AM
To: Ken Winter; 'Zope-DB List'
Subject: Re: [Zope-DB] Two actions in one ZSQL method = one transaction?

...

> Does a ZSQL method initiate a database transaction,
so
> that no other user can inset another record between the two actions in
> this ZSQL method?
>

*If* you database provides
transaction support and *if* your DA integrates with the transaction of
Zope
*then* everything happening within one Zope request will happen within
one Zope transaction and therefore within one DB transaction. This isn't
necessarily true to databases like MySQL.

-aj

My database is PostgreSQL 8.x and my adapter is ZPsyocopgDA.  Does this
combination provide the transaction support you're talking about?

*Of course*

-aj

pgpcUMmhhtNvJ.pgp
Description: PGP signature

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db