[PyGreSQL] callproc() and Stored Procedures

[Martha Zimet]

It's not just the Web page.. I have also tried
via Python at the command line and that also 
does not work for pg and pgdb. That is, calling
the stored proc does not return anything. However,
using psql I am able to return the correct parameter.


On Sat Mar  1 15:59 , "D"Arcy J.M. Cain"  sent:

>On Sat, 01 Mar 2008 15:34:52 -0500
>Martha Zimet zimet at manray.com> wrote:
>> > What does this return when you run it with psql?
>> 
>> Hmm.. 
>> 
>> Running with psql works correctly:
>> 
>> # psql -d db_main
>> 
>> db_main=# SELECT zexternal_action.hello_world('foo');
>> hello_world
>> -----------
>> param provided: foo
>> (1 row)
>> 
>> I am stumped since this works fine. 
>
>When you say that it doesn't work with pg, do you mean a web page
>driven by pg?  If so, check the permissions on the function.
>
>-- 
>D'Arcy J.M. Cain
>PyGreSQL Development Group
>http://www.PyGreSQL.org