RE: Two actions in one ZSQL method = one transaction?

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

~ Thanks
~ Ken