From: Michael Meskes <meskes@postgresql.org>
To: Owens, Steve <Steve.Owens@xerox.com>
Cc: Pgsql-Interfaces (E-mail) <pgsql-interfaces@postgresql.org>
Subject: Re: Interesting ECPG error
Date: Mon, 21 Jun 2004 08:38:55 +0200
Message-ID: <20040621063855.GA4610@1> (raw)
In-Reply-To: <309AD90BD8FC7E4383DB1ACCBF6C8DC0032076@usa0300ms01.na.xerox.net>
References: <309AD90BD8FC7E4383DB1ACCBF6C8DC0032076@usa0300ms01.na.xerox.net>
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: meskes@postgresql.org, Steve.Owens@xerox.com
Subject: Re: Interesting ECPG error
In-Reply-To: <20040621063855.GA4610@1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox