Re: callproc() and Stored Procedures

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 zimetmanray.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


_______________________________________________
PyGreSQL mailing list
PyGreSQLVex.Net
http
://mailman.vex.net/mailman/listinfo/pygresql

On Sat, 01 Mar 2008 16:06:09 -0500
Martha Zimet <zimetmanray.com> wrote:
> 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.

Please post your exact and complete SQL that creates the
function and
the Python script that accesses it.

-- 
D'Arcy J.M. Cain
PyGreSQL Development Group
http://www.PyGreSQL.org
_______________________________________________
PyGreSQL mailing list
PyGreSQLVex.Net
http
://mailman.vex.net/mailman/listinfo/pygresql