[GENERAL] Re: How to set auto commit off in postgresql db?

2001-01-11 Thread J.H.M. Dassen (Ray)
[Please don't mail in HTML] On Thu, Jan 11, 2001 at 21:02:56 -, Guang Mei wrote: It seems to me that postgresql db's default set for commit is "on". Erm, it's not PostgreSQL itself, but rather the "psql" interface. I would like to set it to "off". How could I do that? By explicitly

[GENERAL] Re: How to set auto commit off in postgresql db?

2001-01-11 Thread Gregory Wood
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: