Re: Weird behavior in transaction handling (Possible bug ?) -- commit fails silently

> With postgres once an error occurs in a transaction
block you need
> to rollback. None of the transaction will commit.
>
> This behaviour makes sense as it assumes that the
transaction block
> is atomic and it should all succeed or all fail.

This is VERY counter-intuitive. I can have really
important data
for say 5 tables which has committed properly but at
the 6th
insert into a non-important auxillary table, I may
encounter a
transient exception. I still want to be able to commit
my data.

There are many similar scenarios such as the above,
right ?

As a programmer, shouldn't it be upto me to decide
when to
commit and when to rollback ? Is this even within
spec ? And
at the very least, commit() should then not fail
SILENTLY ! (and
this should be documented).

:-]

Best regards,

--j

__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail