RE: Two actions in one ZSQL method = one transaction?
Andreas Jung <[email protected]> Thu, 14 Jun 2007 16:48:17 +0200
| Newsgroups | gmane.comp.web.zope.database |
|---|---|
| Message-ID | <[email protected]> |
--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 _______________________________________________ Zope-DB mailing list [email protected] http://mail.zope.org/mailman/listinfo/zope-db
signature.asc
(application/pgp-signature, 186 B)
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (Darwin) iD8DBQFGcVUxCJIWIbr9KYwRAvLQAKCgAuNCNXpWAa1p8qhT6CeGvsMbTACggtpO 7whSUPBawjnKKa1LuOOUxbs= =zC93 -----END PGP SIGNATURE-----