[Chicago] auto incrementing - what options do we have?

[Lukasz Szybalski]

On Fri, Oct 10, 2008 at 11:43 AM, David Durham, Jr.
<david.durham.jr at gmail.com> wrote:
> On 10/10/08, Kumar McMillan <kumar.mcmillan at gmail.com> wrote:
>>  Actually, you might have to explicitly declare table level locks as
>>  opposed to row level locks.  Most dbs support LOCK TABLES, i.e. for
>>  myql : http://dev.mysql.com/doc/refman/5.0/en/lock-tables.html which
>>  is what you want in this case.
>
> Right, but locking is not the only way to ensure transaction
> integrity.  It's better to stick with simply setting transaction
> isolation to what you need and letting the db deal with whether or not
> it will use locking or something like MVCC.

So what would be the transaction isolation in this case? Is that
session option or do I change it only on first insert?

Lucas