I was thinking to change isolation level in fact. But first, I don't know how to do this with sqlalchemy, second, with default isolation level commits should work properly weather or not something were inserted or updated during commit and third, I was using nested transaction like this :
transaction = session.begin() nested = session.begin_nested() try: ..insert.. #trying to insert values to column that have UNIQUE constraint except: ..update.. nested.commit() transaction.commit() so, I'm not sure that done everything right. btw, there's a daemon, and have no user to watch on it. On 23 нояб, 09:43, Sanjay <[EMAIL PROTECTED]> wrote: > I think all one can do is just forget and start over again, when > concurrent modifications error occurs. That means, catchig the > exception and just showing some failure message to the user is all one > can do. > > Sanjay --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---