what cvs version are you working with? Dave On Wed, 2003-02-26 at 01:11, Tom Lane wrote: > 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 -- Dave Cramer <[EMAIL PROTECTED]> Cramer Consulting
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]