Re: OT: Question about transactions

On Tue, Aug 12, 2008 at 04:09:48PM -0400, Paul Tomblin wrote:
> they go to process the second message?  Could they do a "BEGIN
> TRANSACTION" at the start and "END TRANSACTION" when they're done
> processing, even though the processing only does queries and not
> updates?

Try SERIALIZABLE mode.  If I understand you correctly, it will do what
you need.

A

--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/