Re: Two features left

Hi all!

my $0.02 on this, though I am not an expert in DBs at all.

>TL> "Timur V. Irmatov" <itvthor(at)sdf(dot)lonestar(dot)org> writes:
>>> It is very simple to implement (i think) it other way - just do
not
>>> force transaction to enter abort state afer exception.
>
>TL> Better study the backend's error handling before you say that.

side-note: I never had a look at this code, but if you want to scare
off people from changing anything there, because it looks too
complicated, it might indicate the need for some refactoring :-)

>but I still insist that using nested transaction to allow
>transactions to continue after SQL exceptions is not a good idea..

What is the whole point of having a nested transaction vs. a single
transaction?
IMHO, if you want to abort all outer transactions when an inner
transaction fails this behaviour would be no different from having
only one transaction for the whole action.

As already stated the outer transactions can check on the return
status of an inner transaction and decide on, what needs to be done in
cause of its failure.

Jan