Re: Nested xacts: looking for testers and review - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Nested xacts: looking for testers and review
Date
Msg-id 3220.1086896354@sss.pgh.pa.us
Whole thread Raw
In response to Re: Nested xacts: looking for testers and review  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Nested xacts: looking for testers and review  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> We are considering allowing COMMIT IGNORE ABORT for scripts that want to
> do a subtransaction, but don't care if it fails, and because it is a
> script, they can't test the return value to send ROLLBACK:

While we clearly want this functionality, I tend to agree with Barry
that COMMIT IGNORE ABORT (and the other variants that have been floated)
is a horrid, confusing name for it.  I would suggest using END with some
modifier, instead.  Perhaps
END [ WORK | TRANSACTION ] [ IGNORE ERRORS ]

END doesn't so directly imply that you are trying to commit a failed
transaction.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Nested xacts: looking for testers and review
Next
From: Alvaro Herrera
Date:
Subject: Re: Nested xacts: looking for testers and review