On Wed, Mar 30, 2005 at 07:46:37PM -0500, Tom Lane wrote:
> "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.
Yes. Definately a PEBCAK issue. :)
--
"To the extent that we overreact, we proffer the terrorists the
greatest tribute."
- High Court Judge Michael Kirby