Re: call stored function from ecpg w/cursor

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: call stored function from ecpg w/cursor
Дата
Msg-id 20070430140101.GA12070@winnie.fuhr.org
обсуждение исходный текст
Ответ на Re: call stored function from ecpg w/cursor  (Andrew Jarcho <ajarcho@nyc.rr.com>)
Ответы Re: call stored function from ecpg w/cursor  (Andrew Jarcho <ajarcho@nyc.rr.com>)
Список 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 по дате отправления:

Предыдущее
От: "Michael Swierczek"
Дата:
Сообщение: Re: PGSQL Query
Следующее
От: Fei Liu
Дата:
Сообщение: Emulating partitioning in postgresql 8.0?