How to do transactions, especially nested hga@xxxxxx (18 Sep 2019 01:22 UTC)
Re: How to do transactions, especially nested Peter Bex (18 Sep 2019 06:05 UTC)
Re: How to do transactions, especially nested Lassi Kortela (18 Sep 2019 07:41 UTC)
Re: How to do transactions, especially nested Peter Bex (18 Sep 2019 07:58 UTC)
Re: How to do transactions, especially nested Lassi Kortela (18 Sep 2019 08:26 UTC)
Re: How to do transactions, especially nested Alaric Snell-Pym (18 Sep 2019 10:27 UTC)
Re: How to do transactions, especially nested Alaric Snell-Pym (18 Sep 2019 10:26 UTC)
Re: How to do transactions, especially nested hga@xxxxxx (18 Sep 2019 15:54 UTC)

Re: How to do transactions, especially nested Alaric Snell-Pym 18 Sep 2019 10:27 UTC
On 18/09/2019 08:58, Peter Bex wrote:
> Perhaps we should treat databases that don't support this as second-class
> and raise an exception when you try to roll back a nested transaction?
> That way, the "happy path" will always work.  Not sure this is great
> design, though.  Raising an exception when trying to make a nested
> transaction could also work, but that means some library code is
> completely unusable in certain databases (how many databases don't have
> these, anyway?).

I should have caught up on the thread before replying :-D

--
Alaric Snell-Pym   (M7KIT)
http://www.snell-pym.org.uk/alaric/