what cvs version are you working with?
Dave
On Wed, 2003-02-26 at 01:11, Tom Lane wrote:
> 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
--
Dave Cramer <dave@fastcrypt.com>
Cramer Consulting