Re: autocommit off mode, how does it work?

Dave Cramer <dave@fastcrypt.com> writes:
> Can someone point me to the documentation for the new autocommit mode
> behaviour, I must be doing something wrong

Must be :-(.  I repeated your example as best I could, and it behaved
as expected.

<< session 1 >>

regression=# set autocommit=off;
SET
regression=# begin;
BEGIN
regression=# create table foo (f1 int);
CREATE TABLE
regression=# insert into foo values (1);
INSERT 933631 1
regression=# end;
COMMIT
regression=#

<< session 2 >>

regression=# \d foo     Table "public.foo"Column |  Type   | Modifiers
--------+---------+-----------f1     | integer |

regression=# select * from foo;f1
---- 1
(1 row)

        regards, tom lane