Re: How to set autocommit on/off - Mailing list pgsql-sql

From Jie Liang
Subject Re: How to set autocommit on/off
Date
Msg-id Pine.BSF.4.21.0012201557300.45028-100000@jliang.ipinc.com
Whole thread Raw
In response to How to set autocommit on/off  ("Kevin" <kevin.lam@crownetravel.com>)
List pgsql-sql
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
> -------------------------------------
> 
> 



pgsql-sql by date:

Previous
From: Sandis Jerics
Date:
Subject: sorting the text values as integers
Next
From: Jie Liang
Date:
Subject: Re: plpgsql ?