On Mar 5, 2011, at 3:11 AM, Matt Warner wrote: > 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.
Error Message is only saying nvl(integer,integer) does not exists. Please check offload database is having function nvl and then, grant all on that function. 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