Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block

On Thu, Sep 12, 2013 at 09:38:43AM +0530, Amit Kapila wrote:
> > I have created the attached patch which issues an error when SET
> > TRANSACTION and SET LOCAL are used outside of transactions:
> >
> >         test=> set transaction isolation level serializable;
> >         ERROR:  SET TRANSACTION can only be used in transaction blocks
> >         test=> reset transaction isolation level;
> >         ERROR:  RESET TRANSACTION can only be used in transaction blocks
> >
> >         test=> set local effective_cache_size = '3MB';
> >         ERROR:  SET LOCAL can only be used in transaction blocks
> >         test=> set local effective_cache_size = default;
> >         ERROR:  SET LOCAL can only be used in transaction blocks
>
> Shouldn't we do it for Set Constraints as well?

Oh, very good point.  I missed that one.  Updated patch attached.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +