Dave Cramer <dave(at)fastcrypt(dot)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