Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block
Date
Msg-id 20131126001953.GB6570@momjian.us
Whole thread Raw
In response to Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Fri, Nov 22, 2013 at 01:19:55PM -0500, Bruce Momjian wrote:
> On Fri, Nov 22, 2013 at 12:17:41PM -0500, Bruce Momjian wrote:
> > Good points.  I have modified the attached patch to do as you suggested.
> 
> Also, I have read through the thread and summarized the positions of the
> posters:
> 
>                           9.3     WARNING                 ERROR
>   SET                     none    Tom, DavidJ, AndresF    Robert, Kevin
>   SAVEPOINT               error                           Tom, DavidJ, Robert, AndresF, Kevin
>   LOCK, DECLARE           error                           Tom, DavidJ, Robert, AndresF, Kevin
> 
> Everyone seems to agree that SAVEPOINT, LOCK, and DECLARE should remain
> as errors.  Everyone also seems to agree that BEGIN and COMMIT should
> remain warnings, and ABORT should be changed from notice to warning.
> 
> Our only disagreement seems to be how to handle the SET commands, which
> used to report nothing.  Would anyone else like to correct or express an
> opinion?  Given the current vote count and backward-compatibility,
> warning seems to be the direction we are heading.

Patch applied.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: INSERT...ON DUPLICATE KEY LOCK FOR UPDATE
Next
From: Stephen Frost
Date:
Subject: Re: Extension Templates S03E11