Someone will correct me if I'm wrong, but I'm pretty sure all you have to do
is start a transaction. Example:
begin;
create table t1 (col1 varchar(10));
insert into t1 (col1) values ('test123');
rollback;
Greg
----- Original Message -----
From: Guang Mei
To: [EMAIL PROTECTED]
Sent: Thursday, January 11, 2001 4:02 PM
Subject: How to set "auto commit" off in postgresql db?
Hi:
It seems to me that postgresql db's default set for commit is "on". I
would like to set it to "off". How could I do that?
TIA.
----------
Here is what I got when testing:
webstore=> create table t1 (col1 varchar(10));
CREATE
webstore=> insert into t1 (col1) values ('test123');
INSERT 1006769 1
webstore=> select * from t1;
col1
---------
test123
(1 row)
webstore=> rollback;
NOTICE: ROLLBACK: no transaction in progress
ROLLBACK
webstore=> select * from t1;
col1
---------
test123
(1 row)
----------------------------------------------------------------------------
--
Get your FREE download of MSN Explorer at http://explorer.msn.com