Re: [GENERAL] vacuum from ecpg

2003-11-16 Thread Michael Meskes
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 Mes

Re: [GENERAL] vacuum from ecpg

2003-11-15 Thread Bruce Momjian
Joshua D. Drake wrote: > Hello, > > 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; -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PRO