Re: call stored function from ecpg w/cursor - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: call stored function from ecpg w/cursor
Date
Msg-id 20070430140101.GA12070@winnie.fuhr.org
Whole thread Raw
In response to Re: call stored function from ecpg w/cursor  (Andrew Jarcho <ajarcho@nyc.rr.com>)
Responses Re: call stored function from ecpg w/cursor
List pgsql-novice
On Sun, Apr 29, 2007 at 03:39:27PM -0400, Andrew Jarcho wrote:
> Thank you very much Michael for your reply. I have tried your
> suggestions, but am still having problems. The code still prints 0 as
> its result, and ECPGdebug reports "raising sqlcode -201 in line ##, 'Too
> many arguments in line ##.'". This is the way the code sample looks now.

Could you post a complete test case instead of just excerpts?  By
"complete" I mean all SQL and C (ECPG) code that somebody could use
in an attempt to reproduce the problem on their system.  When pieces
are missing we have to guess at what those pieces are and then we
can't be certain that we've created the same conditions as on your
system.

What OS and version of PostgreSQL are you using?  What compiler?
Did you regenerate the .c file after changing the .pgc file?

> in file floop.pgc:
[...]
> RETURN -1;

This code doesn't even compile on my system because of "RETURN"
instead of "return".  Are you sure you're compiling and running the
code you think you are?

--
Michael Fuhr

pgsql-novice by date:

Previous
From: "Michael Swierczek"
Date:
Subject: Re: PGSQL Query
Next
From: Fei Liu
Date:
Subject: Emulating partitioning in postgresql 8.0?