"CaT" <cat(at)zip(dot)com(dot)au> writes:
> = holly(at)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