Skip site navigation (1) Skip section navigation (2)

Re: BUG #1571: Cannot grant execute functions to non-superusers

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "CaT" <cat(at)zip(dot)com(dot)au>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1571: Cannot grant execute functions to non-superusers
Date: 2005-03-31 00:46:37
Message-ID: 527.1112229997@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"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

In response to

Responses

pgsql-bugs by date

Next:From: CaTDate: 2005-03-31 00:49:31
Subject: Re: BUG #1571: Cannot grant execute functions to non-superusers
Previous:From: CaTDate: 2005-03-31 00:39:55
Subject: Re: BUG #1571: Cannot grant execute functions to non-superusers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group