[PyGreSQL] callproc() and Stored Procedures

[D'Arcy J.M. Cain]

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