Skip site navigation (1) Skip section navigation (2)

Re: [PATCHES] nested xacts and phantom Xids

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCHES] nested xacts and phantom Xids
Date: 2004-06-26 18:09:53
Message-ID: 874qoy5gy6.fsf@stark.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)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


In response to

pgsql-hackers by date

Next:From: jacob koehler (RRes-Roth)Date: 2004-06-26 19:20:51
Subject: recursive SQL
Previous:From: Alvaro HerreraDate: 2004-06-26 17:28:23
Subject: Re: PREPARE and transactions

pgsql-patches by date

Next:From: Tom LaneDate: 2004-06-26 23:56:09
Subject: Re: nested xacts and phantom Xids
Previous:From: Dennis BjorklundDate: 2004-06-26 05:26:38
Subject: Re: [PATCHES] nested xacts and phantom Xids

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group