X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9C9B7D1B1B0 for ; Mon, 21 Jun 2004 05:19:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 68859-08 for ; Mon, 21 Jun 2004 08:19:10 +0000 (GMT) Received: from curie.credativ.org (credativ.com [217.160.209.18]) by svr1.postgresql.org (Postfix) with ESMTP id B6BFCD1B1AB for ; Mon, 21 Jun 2004 05:19:07 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by curie.credativ.org (Postfix) with ESMTP id 68FC955BCA; Mon, 21 Jun 2004 10:19:07 +0200 (CEST) Received: from www.credativ.de (pD9FFE2AD.dip0.t-ipconnect.de [217.255.226.173]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by curie.credativ.org (Postfix) with ESMTP id EA8F255BC8; Mon, 21 Jun 2004 10:19:06 +0200 (CEST) Received: from feivel (feivel.credativ.de [172.26.14.57]) by www.credativ.de (Postfix) with ESMTP id E24391C0018; Mon, 21 Jun 2004 10:19:03 +0200 (CEST) Received: by feivel (Postfix, from userid 1000) id 8E64D4AD9C; Mon, 21 Jun 2004 08:38:56 +0200 (CEST) Date: Mon, 21 Jun 2004 08:38:55 +0200 From: Michael Meskes To: "Owens, Steve" Cc: "Pgsql-Interfaces (E-mail)" Subject: Re: Interesting ECPG error Message-ID: <20040621063855.GA4610@1> Mail-Followup-To: "Owens, Steve" , "Pgsql-Interfaces (E-mail)" References: <309AD90BD8FC7E4383DB1ACCBF6C8DC0032076@usa0300ms01.na.xerox.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <309AD90BD8FC7E4383DB1ACCBF6C8DC0032076@usa0300ms01.na.xerox.net> User-Agent: Mutt/1.5.6+20040523i X-Virus-Scanned: by AMaViS at credativ.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200406/50 X-Sequence-Number: 4978 On Fri, Jun 18, 2004 at 05:11:01PM -0400, Owens, Steve wrote: > > I'm running 7.4.2 and using ECPG's dynamic SQL capabilities to run some pgplsql functions in a database, some of which just insert records into a table. The dynamic SQL statement looks something like this: > ... Could you please run your program with logging enabled? Therefore you just have to add this at the beginning of your program: FILE *dbgs; if ((dbgs = fopen("log", "w")) != NULL) ECPGdebug(1, dbgs); and an fclose(dbgs) at the end of course. This creates a file named "log". Then please send me that file. I'd like to see what's going on. -220 btw is "No Connection" so I assume you mean -202 which is given if a "?" is left after processing of all variables. Also could you please send me the .pgc file and your .c file, i.e. ecpg's output? Preferably in a small test case. Thanks. 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!