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

[Ken Winter]

Great! Thanks again.

> -----Original Message-----
> From: Andreas Jung [mailto:lists at zopyx.com]
> Sent: Thursday, June 14, 2007 10:48 AM
> To: Ken Winter; 'Andreas Jung'; 'Zope-DB List'
> Subject: RE: [Zope-DB] Two actions in one ZSQL method = one transaction?
> 
> 
> 
> --On 14. Juni 2007 10:41:46 -0400 Ken Winter <ken at sunward.org> wrote:
> 
> >> -----Original Message-----
> >> From: Andreas Jung [mailto:lists at zopyx.com]
> >> 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