[Zope] atomic operations

You aren't having to worry about this. last_insert_id is per connection, and not confused by activitiy across connections. Otherwise, mySQL is decidely non-transactional. postgresql has that.





> ------------ Original Message -----------
> From: Gustavo Vieira Goncalves Coelho Rios <gustavo@ifour.com.br>
> Date: Thu, 26 Jul 2001 15:26:02 -0300
> 
> Hi folks!
> 
> I have a table it has an auto increment fields. How could i have the id id
> insert by my last query atomically? I know i could use last_insert_id()
> function with MySQL, but since my mysql handler is shared by many instances of
> Zope, i cannot garantee that no other query runs between the insert and
> the select last_insert_id queries.
> 
> Any ideia ?
> 
> -- 
> There is only one thing in the world worse than being talked about, and
> that is not being talked about.
> 		-- Oscar Wilde
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )