Skip site navigation (1) Skip section navigation (2)

Re: autocommit off mode, how does it work?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Cramer <dave(at)fastcrypt(dot)com>
Cc: "'pgsql-hackers'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: autocommit off mode, how does it work?
Date: 2003-02-26 06:11:11
Message-ID: 27375.1046239871@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Christopher Kings-LynneDate: 2003-02-26 06:24:04
Subject: quick question
Previous:From: Dave CramerDate: 2003-02-26 05:26:48
Subject: autocommit off mode, how does it work?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group