Re: Nested Transactions, Abort All

On Tue, Jul 06, 2004 at 12:49:46PM -0400, Stephen Frost wrote:
> * Alvaro Herrera (alvherre(at)dcc(dot)uchile(dot)cl) wrote:
> > We could use BEGIN NESTED for starting a subtransaction, roll it back
> > with ROLLBACK NESTED or some such, and commit with COMMIT NESTED. But I
> > like SUBBEGIN etc best, and no one had an opinion when I asked. So the
> > current code has SUBBEGIN, SUBCOMMIT, SUBABORT. If people prefer
>
> Just to be pedantic and talking about consistency-
> Why SUBABORT instead of SUBROLLBACK?

Just because it's ugly and too long ... I think the standard spelling is
ROLLBACK, and ABORT is a Postgres extension. Since nested xacts are a
Postgres extension, we might as well extend our own syntax :-)

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
La web junta la gente porque no importa que clase de mutante sexual seas,
tienes millones de posibles parejas. Pon "buscar gente que tengan sexo con
ciervos incendiánse", y el computador dirá "especifique el tipo de ciervo"
(Jason Alexander)