Re: SET autocommit begins transaction? - Mailing list pgsql-bugs

From Rod Taylor
Subject Re: SET autocommit begins transaction?
Date
Msg-id 1032395130.47165.6.camel@jester
Whole thread Raw
In response to Re: SET autocommit begins transaction?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: SET autocommit begins transaction?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
> > What about that doesn't make sense?  Having SET begin a transaction
> > seems like a gross violation of POLS and likely to contradict the spec
> > and cause problems with many applications.  -sc
>
> I think we left the standard when we made SET rollbackable.  Maybe that
> has to be reopened because if we did that, it would make perfect sense
> because all SETs would be outside transactions.

Of course, the reason they're rollbackable is:

begin;
create schema newschema;
set search_path = newschema;
rollback;

create table junk;  -- DOH!

--
  Rod Taylor

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SET autocommit begins transaction?
Next
From: Bruce Momjian
Date:
Subject: Re: SET autocommit begins transaction?