Re: [PATCHES] nested xacts and phantom Xids - Mailing list pgsql-hackers

From Greg Stark
Subject Re: [PATCHES] nested xacts and phantom Xids
Date
Msg-id 874qoy5gy6.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: [PATCHES] nested xacts and phantom Xids  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PREPARE and transactions
Next
From: "jacob koehler (RRes-Roth)"
Date:
Subject: recursive SQL