[Dbix-class] is it safe use find_or_create in "read committed" transaction level

Bill Crawford billcrawford1970 at gmail.com
Mon Sep 20 13:54:32 GMT 2010


On 20 September 2010 14:04, Peter Rabbitson <rabbit+dbic at rabbit.us> wrote:

> Savepoints do not help here. An error happening within a savepoint
> invalidates *the entire transaction*. Test it on your RDBMS, but
> I am pretty sure this is the case all-around.

Work fine, but if you have two clients trying to insert, the second
one hangs until the first one commits the whole transaction, not just
releases the savepoint. So it would probably be counterproductive
anyway :-/



More information about the DBIx-Class mailing list