Skip site navigation (1) Skip section navigation (2)

Re: Interesting ECPG error

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: "Owens, Steve" <Steve(dot)Owens(at)xerox(dot)com>
Cc: "Pgsql-Interfaces (E-mail)" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Interesting ECPG error
Date: 2004-06-21 06:38:55
Message-ID: 20040621063855.GA4610@1 (view raw or flat)
Thread:
Lists: pgsql-interfaces
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(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!

In response to

pgsql-interfaces by date

Next:From: Michael MeskesDate: 2004-06-22 06:53:10
Subject: Re: 'execute immediate' problem
Previous:From: L J BayukDate: 2004-06-21 01:05:54
Subject: Released updated Tcl interfaces: pgin.tcl-2.1.0, pgtclng-1.5.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group