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

> > Of course, the reason they're rollbackable is:
> >
> > begin;
> > create schema newschema;
> > set search_path = newschema;
> > rollback;
> >
> > create table junk;  -- DOH!
>
> And:
>
>     set statement_timeout = 20;
>     query_with_error;
>     set statement_timeout = 0;
>     COMMIT;
>
> That will have to change in autocommit off to:
>
>     BEGIN;
>     SET statement_timeout = 20;
>     query_with_error;
>     SET statement_timeout = 0;
>     COMMIT;
>
> I assume that BEGIN does start a transaction.  With no BEGIN above, the
> big problem is that it will work most of the time, but when/if the query
> fails, they will find out they forgot the BEGIN.

Wouldn't it roll back to 0 though because the SET statement_timeout TO
20 was inside of a transaction (assuming the value was 0 before the
transaction began)?  -sc

--
Sean Chittenden