Re: Nested Transactions, Abort All - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Nested Transactions, Abort All
Date
Msg-id 3555.1088811827@sss.pgh.pa.us
Whole thread Raw
In response to Re: Nested Transactions, Abort All  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: Nested Transactions, Abort All  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> You can't have subtransactions inside an implicit transaction block,

It would be folly to design on that assumption.  We *will* have that
situation just as soon as plpgsql allows creating subtransactions
(which I trust you'll agree will happen soon).  All you have to do
is call such a function from a bare SELECT.  I do not think you'll
be able to legislate that people must say BEGIN first.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: Re: [Re] Re: PREPARE and transactions
Next
From: Oliver Jowett
Date:
Subject: Re: [Re] Re: PREPARE and transactions