Thread: How to set autocommit on/off

How to set autocommit on/off

From
"Kevin"
Date:
As titled, is autocommit of Postgresql is default to be "ON", how to turn it
off then?

Thnaks,
Kevin

--
-------------------------------------
Kevin LAM, System Analyst
Crown Development Ltd.
A Shun Tak Group Company

Tel: (852) 2283-2132
Fax:(852) 2283-2727
-------------------------------------




Re: How to set autocommit on/off

From
Jie Liang
Date:
Hi, there,

I think you can use :
BEGIN;        -- turn off

any DDL stmts


-- you can rollback them by
ROLLBACK;

END|COMMIT;   -- turn on

Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com

On Wed, 20 Dec 2000, Kevin wrote:

> As titled, is autocommit of Postgresql is default to be "ON", how to turn it
> off then?
> 
> Thnaks,
> Kevin
> 
> --
> -------------------------------------
> Kevin LAM, System Analyst
> Crown Development Ltd.
> A Shun Tak Group Company
> 
> Tel: (852) 2283-2132
> Fax:(852) 2283-2727
> -------------------------------------
> 
>