[sqlalchemy] Re: Concurrency control using version_id_col

2007-06-26 Thread Sanjay
Hi Mike, Thanks a lot. It works fine (with or without default=0). The problem was in my TG application, which was not preserving version while populating the edit form. I made version as a hidden field in the form, and it works fine now. Sanjay

[sqlalchemy] Re: Concurrency control using version_id_col

2007-06-21 Thread Michael Bayer
On Jun 21, 2007, at 4:50 AM, Sanjay wrote: Hi, In order to achieve concurrency control using optimistic locking, we are doing the following: 1. Adding a column in the table like this: page_tbl = Table('page', metadata, Column('page_id', Integer, primary_key=True,