On 20 September 2010 14:04, Peter Rabbitson <[email protected]> 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.

Hmm. PG docs say:

"Moreover, ROLLBACK TO is the only way to regain control of a
transaction block that was put in aborted state by the system due to
an error, short of rolling it back completely and starting again."

which I thought implied that you can rollback to a savepoint after an
error. I'll try it out ...

_______________________________________________
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]

Reply via email to