Joerg Braun wrote: > On Tue, 19 Jun 2012 10:26:19 +0100, Dave Howorth >> I still don't understand the UPDATE vs INSERT issue. >> > In his first mail he told us that a user has to seelct a minimum value from > some table. That has to be valid until the insert committed. He wants to > avoid a second user in receiving the same minimum value. > > His idea was to lock the table for reading until the insert is done, which > would create a new minimum value.
SELECT FOR UPDATE locks for UPDATE, not for INSERT, according to the manual. _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
