Re: [Zope] Concurrency/Atomicity in ZSQL/ZOracleDA ?

Renaud Guérin wrote:

...

ly instead of in parallel.

I think I need to lock the table against reads, not inserts. What I must ensure is that no more select's max(id)+1 can be done before the subsequent insert is completed. I don't know how to use LOCK to do that, anyone ?

thanks

You want LOCK TABLE table IN EXCLUSIVE MODE; most likely. A second lock statement will block until the first one clears. -- Matt Kromer Zope Corporation http://www.zope.com/