Re: [PATCHES] nested xacts and phantom Xids

Alvaro Herrera <alvherre@dcc.uchile.cl> writes:

> It has been suggested a couple of times that we should use a different
> syntax for subtransactions than for main transactions.  This would for
> example allow things like
> 
> 
> BEGIN;
>     do something;
>     SUBBEGIN;

It might be awkward for clients like psql that will want to execute every
command in a nested transaction. It would mean they would have to know whether
the user has started a transaction or not in order to know whether to use
"BEGIN" or "SUBBEGIN". But I guess they would have to do that anyways unless
there's some protocol level way to indicate a query should be executed in a
nested transaction.

-- 
greg