*** 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.kumar@xxxxxxxxxxxxxxxx> wrote:
GRANT all on function nvl to public would help.
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.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@xxxxxxxxxxxxxxxx
Blog:http://vibhork.blogspot.com
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
