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

2005-03-30 Thread CaT
On Wed, Mar 30, 2005 at 07:46:37PM -0500, Tom Lane wrote: > "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 pla

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

2005-03-30 Thread Tom Lane
"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

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

2005-03-30 Thread CaT
On Thu, Mar 31, 2005 at 01:07:56AM +0100, CaT wrote: > > The following bug has been logged online: > > Bug reference: 1571 > Logged by: CaT > Email address: [EMAIL PROTECTED] > PostgreSQL version: 7.4.7 > Operating system: Linux (Debian woody with backports.org pgsql) > Descr

[BUGS] BUG #1571: Cannot grant execute functions to non-superusers

2005-03-30 Thread CaT
The following bug has been logged online: Bug reference: 1571 Logged by: CaT Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: Linux (Debian woody with backports.org pgsql) Description:Cannot grant execute functions to non-superusers Details