Here's how the script is defining the function, if that helps: CREATE FUNCTION nvl(anyelement, anyelement) RETURNS anyelement AS '$libdir/orafunc','ora_nvl' LANGUAGE C IMMUTABLE;
On Fri, Mar 4, 2011 at 1:41 PM, Matt Warner <m...@warnertechnology.com>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. > > > On Fri, Mar 4, 2011 at 1:34 PM, Vibhor Kumar < > vibhor.ku...@enterprisedb.com> wrote: > >> >> On Mar 5, 2011, at 2:50 AM, John R Pierce wrote: >> >> > On 03/04/11 1:11 PM, Matt Warner wrote: >> >> Good afternoon. >> >> >> >> I've been looking at the Oracle Functionality package. ... >> > >> > what is this? doesn't sound like anything in PostgreSQL I'm familiar >> with. Is this part of EntepriseDB's Postgres+ package or something? You >> should probably contact them via their support channels. >> >> >> GRANT all on function nvl to public would help. >> >> >> Thanks & Regards, >> Vibhor Kumar >> EnterpriseDB Corporation >> The Enterprise PostgreSQL Company >> vibhor.ku...@enterprisedb.com >> Blog:http://vibhork.blogspot.com >> >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >
