On Fri, Mar 4, 2011 at 1:49 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 03/04/11 1:41 PM, Matt Warner wrote:what schema is this function defined in? is that schema in the search path?
No luck:
*** as postgres
postgres=# GRANT all on function nvl(anyelement,anyelement) to public;
GRANT
postgres=#
*** as unprivileged user
offload=> select nvl(0,1);
ERROR: function nvl(integer, integer) does not exist
LINE 1: select nvl(0,1);
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
l
The function was loaded as user postgres since it's a C-language module. The definitions for most of the functions in the script have pg_catalog as the prefix (e.g. CREATE FUNCTION pg_catalog.to_date(str text)).
