Re: autocommit off mode, how does it work?

From: Dave Cramer <dave(at)fastcrypt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 'pgsql-hackers' <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: autocommit off mode, how does it work?
Date: 2003-02-26 07:19:25
Message-ID: 1046243964.625.147.camel@inspiron.cramers
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

what cvs version are you working with?

Dave
On Wed, 2003-02-26 at 01:11, Tom Lane wrote:
> 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
--
Dave Cramer <dave(at)fastcrypt(dot)com>
Cramer Consulting

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-02-26 07:29:23 Re: Index File growing big.
Previous Message Tom Lane 2003-02-26 06:56:48 Re: CHECK constraints in pg_dump