On Fri, Mar 4, 2011 at 1:49 PM, John R Pierce <pie...@hogranch.com> wrote:
> On 03/04/11 1:41 PM, Matt Warner wrote: > >> 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. >> >> > what schema is this function defined in? is that schema in the search > path? > > > l <http://www.postgresql.org/mailpref/pgsql-general> 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)).
