Problem granting access to a PlPython function

From: Mariano Mara <mariano(dot)mara(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Problem granting access to a PlPython function
Date: 2009-11-08 20:07:16
Message-ID: 1257708754-sup-7248@kafka
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have this plpython function that I need to execute with a non
superuser. I logged in the postgres account, create it and grant execute
rights to the target user.
However I cannot execute it with this user: I'm getting a "function ...
does not exist" error and after poking it for a few hours without luck,
it seems this problem is too much for a n00b like me.
Can anyone offer a hint how to make it work?
Following is a full example of what I'm doing:

# su - postgres
-bash-3.2$ psql -f hours_pgsql_function.sql
CREATE FUNCTION
-bash-3.2$ psql
Welcome to psql 8.3.8, the PostgreSQL interactive terminal.

postgres=# select hours_between(localtimestamp, localtimestamp,
cast('Argentina' as character varying));
hours_between
---------------
0
(1 row)

postgres=# grant execute on function hours_between (timestamp without
time zone, timestamp without time zone, character varying) to otrs;
GRANT
postgres=# \q
-bash-3.2$ psql -d otrs -U otrs
Welcome to psql 8.3.8, the PostgreSQL interactive terminal.

otrs=> select hours_between(localtimestamp, localtimestamp,
cast('Argentina' as character varying));
ERROR: function hours_between(timestamp without time zone, timestamp
without time zone, character varying) does not exist
LINE 1: select hours_between(localtimestamp, localtimestamp, cast('A...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
otrs=>

TIA,
Mariano.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-11-08 20:18:52 Re: Problem granting access to a PlPython function
Previous Message Sam Mason 2009-11-08 19:32:55 Re: Problem to use remote cygwin server using ssh and native psql 8.3.5