Re: vacuum from ecpg

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: vacuum from ecpg
Date: 2003-11-15 19:37:28
Message-ID: 20031115193728.GA2496@feivel.fam-meskes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-11-15 20:41:29 Re: vacuum from ecpg
Previous Message Christopher Browne 2003-11-15 16:52:14 Re: ATA disks and RAID controllers for database servers