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
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 |