transactions within transactions.

[SamDonaldson]

Hello,

I have a question on transaction blocks within transactions. Does the
parent transaction just inherit all the embedded transactions in it or
are they treated separately? In other words, can an inner trnasaction
block get committed bofore we call the outside block's commit?

Thanks.

[Diez B. Roggisch]

If your DB actually supports nested transactions they will always be nested -
that is if transaction B is inside transaction A, and you rollback A, B will
be rolled back as well. Which is the sole purpose behind nested transactions.

Diez

[SamDonaldson]

My question actually has to do with Turbogears transactions. The ones
you can declare off the session? What happens when you define these
in a nested way?

Thanks,

Sam.

On Jun 26, 4:31 am, "Diez B. Roggisch" <diez.roggi...@artnology.com>
wrote:

[Diez B. Roggisch]

SamDonaldson schrieb:

> My question actually has to do with Turbogears transactions. The ones
> you can declare off the session? What happens when you define these
> in a nested way?

The same thing. Nested transactions is something a database has to
support. The TG API just calls the sql-api's functions, and that's it.

diez