[Chicago] auto incrementing - what options do we have?
David Durham, Jr.
david.durham.jr at gmail.com
Fri Oct 10 19:31:46 CEST 2008
> > So what would be the transaction isolation in this case? Is that
> > session option or do I change it only on first insert?
>
> I think you want repeatable read or read serializable. Here's a
> Google feeling lucky for read serializable:
>
> http://www.devx.com/getHelpOn/10MinuteSolution/16488/1954
..
Forgot to say that this can look like this:
set transaction isolation level read serializable
and yes, this applies to an SQL Session.
-Dave
More information about the Chicago
mailing list