Received: from amer-mta01.csc.com (amer-mta01.csc.com [20.137.2.247]) by postgresql.org (Postfix) with ESMTP id 5B6A24758F1 for ; Thu, 1 Aug 2002 18:22:15 -0400 (EDT) Received: from amer-mta01.csc.com (localhost [127.0.0.1]) by amer-mta01.csc.com (Switch-2.2.2/Switch-2.2.0) with ESMTP id g71MMjS21462 for ; Thu, 1 Aug 2002 18:22:45 -0400 (EDT) Received: from csc.com (va-fch31.csc.com [20.6.39.231]) by amer-mta01.csc.com (Switch-2.2.2/Switch-2.2.0) with ESMTP id g71MMjS21458 for ; Thu, 1 Aug 2002 18:22:45 -0400 (EDT) Subject: Re: ECPG - Meaning of -400, ECPG_PGSQL? To: pgsql-interfaces@postgresql.org X-Mailer: Lotus Notes Release 5.0.6a January 17, 2001 Message-ID: From: "William West" Date: Thu, 1 Aug 2002 18:22:04 -0400 X-MIMETrack: Serialize by Router on VA-FCH31/SRV/CSC(Release 5.0.8 |June 18, 2001) at 08/01/2002 06:28:26 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Archive-Number: 200208/7 X-Sequence-Number: 2969 Doh! I found the '-t' switch to 'ecpg'. I am a 'newbie' and there is a >LOT< to read and I somehow missed it (somehow had it in my head that the >default< was explicit transaction BEGIN-COMMIT). . William West/CIV/CSC To: pgsql-interfaces@postgresql.org @CSC cc: Sent by: Subject: [INTERFACES] ECPG - Meaning of -400, ECPG_PGSQL? pgsql-interfa ces-owner 07/31/2002 07:48 PM Goal is to TRUNCATE table, then DROP table, then VACUUM (everything) then (re)ADD table as part of an ECPG application's initialization.