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: [EMAIL PROTECTED] Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL! ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match