Re: vacuum from ecpg - Mailing list pgsql-general

From Michael Meskes
Subject Re: vacuum from ecpg
Date
Msg-id 20031115193728.GA2496@feivel.fam-meskes.de
Whole thread Raw
In response to Re: vacuum from ecpg  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
On Sat, Nov 15, 2003 at 11:31:08PM -0500, Bruce Momjian wrote:
> > I might be wrong on this but I think that ecpg using transactions by
> > default for each query.
> > Perhaps turning on autocommit?
>
> Yep, use:
>
>     EXEC SQL SET AUTOCOMMIT = ON;

Or use 'ecpg -t'.

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

pgsql-general by date:

Previous
From: "Keith C. Perry"
Date:
Subject: Retoring non-administrative user databases
Next
From: Peter Eisentraut
Date:
Subject: Re: Retoring non-administrative user databases