Re: BUG #1571: Cannot grant execute functions to non-superusers - Mailing list pgsql-bugs

On Wed, Mar 30, 2005 at 07:46:37PM -0500, Tom Lane wrote:
> "CaT" <cat@zip.com.au> writes:
> > = holly@hollydb:/holly> select gen_salt('md5'::text);
> > ERROR:  42883: function gen_salt(text) does not exist
>
> This is not a permissions problem, it's a "you're not looking in the
> right place" problem.  I speculate that either you loaded the functions
> in the wrong database, or holly for some reason doesn't have the public
> schema in her search path.

Yes. Definately a PEBCAK issue. :)

--
    "To the extent that we overreact, we proffer the terrorists the
    greatest tribute."
        - High Court Judge Michael Kirby