2010/9/6 Adam Chlipala <ad...@impredicative.com>: > Vladimir Shabanov wrote: >> I think it would be nice to have possibility to manually restart >> transaction so DB still can be accessed after error. >> > > After I sent the above message, I realized that some kind of compensating > action was necessary to make this feature at all useful for Postgres. > Otherwise, a transaction wouldn't be able to commit after an error, so any > actions an application had taken in response to the error would be rolled > back. Because of this, I'm planning to add a savepoint before every piece > of DML executed by the new function.
So savepoint will be introduced only where it really needed (dml with user error handling)? I think that this is the best solution. BTW it can be useful to have function for cancelling (and maybe restarting) transaction as a part of error handling. _______________________________________________ Ur mailing list Ur@impredicative.com http://www.impredicative.com/cgi-bin/mailman/listinfo/ur