Re: How to set autocommit on/off

From: Jie Liang <jliang(at)jliang(dot)ipinc(dot)com>
To: Kevin <kevin(dot)lam(at)crownetravel(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to set autocommit on/off
Date: 2000-12-21 00:00:15
Message-ID: Pine.BSF.4.21.0012201557300.45028-100000@jliang.ipinc.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(at)ipinc(dot)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
> -------------------------------------
>
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2000-12-21 00:18:01 Re: plpgsql ?
Previous Message Kovacs Zoltan Sandor 2000-12-20 20:51:26 Re: plpgsql ?