Dave Cramer <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly