"CaT" <[EMAIL PROTECTED]> writes:
> = [EMAIL PROTECTED]:/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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
