Re: BEGIN inside transaction should be an error - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: BEGIN inside transaction should be an error
Date
Msg-id 20060510081016.GA14476@svana.org
Whole thread Raw
In response to Re: BEGIN inside transaction should be an error  (Mario Weilguni <mweilguni@sime.com>)
Responses Re: BEGIN inside transaction should be an error
Re: BEGIN inside transaction should be an error
List pgsql-hackers
On Wed, May 10, 2006 at 09:41:46AM +0200, Mario Weilguni wrote:
> > > Could we make BEGIN fail when we already are in a transaction?
> >
> > We could, but it'd probably break about as many apps as it fixed.
> > I wonder whether php shouldn't be complaining about this, instead
> > --- doesn't php have its own ideas about controlling where the
> > transaction commit points are?
>
> In fact it would break many application, so it should be at least controllable
> by a setting or GUC.

You want to make a GUC that makes:

BEGIN;
BEGIN;

Leave you with an aborted transaction? That seems like a singularly
useless feature...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: Mario Weilguni
Date:
Subject: Re: BEGIN inside transaction should be an error
Next
From: Mario Weilguni
Date:
Subject: Re: BEGIN inside transaction should be an error