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

"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.

            regards, tom lane