Forum OpenACS Q&A: Re: how do you get locking transactions to work?

Collapse
Posted by Andrew Piskorski on
Derick's and Claudio's comments are exactly right, you should never use more than one database handle within a single db_transaction block. Breaking that rule is a problem that periodically pops up here in the forums. A good fix would be to implement this: db_transaction should throw error for multiple database handles.

It's not clear to me that this actually had anything directly to do with Robert's problem, but it's good advice regardless.