Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-03-30 Thread Bruce Momjian
Neil Conway wrote: > Alvaro Herrera wrote: > > I believe on Windows the file is called pgpass.conf instead? > > The SGML docs pretty consistently only mention "~/.pgpass" when > referencing this feature, so I didn't bother mentioning the other name > in the pg_autovacuum README. Perhaps someone

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

Re: [BUGS] foreign key constraint not working when index tablespace

2005-03-30 Thread Joel Krajden
I don't think I am crazy and the user who showed me the problem exists - but damn it neither he or I cannot duplicate the problem. The only thing that changed is each of us has logged out of our session and logged back in. The only thing that could have happened is that sometime in the past the

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-03-30 Thread Neil Conway
Alvaro Herrera wrote: I believe on Windows the file is called pgpass.conf instead? The SGML docs pretty consistently only mention "~/.pgpass" when referencing this feature, so I didn't bother mentioning the other name in the pg_autovacuum README. Perhaps someone should fix the SGML docs to refer

Re: [BUGS] BUG #1567: can't hide password with pg_autovacuum

2005-03-30 Thread Alvaro Herrera
On Wed, Mar 30, 2005 at 03:06:44PM +1000, Neil Conway wrote: > Matthew T. O'Connor wrote: > >I believe that pg_autovacuum will work with a .pgpass file just like any > >libpq based application. > > It should, yes. I've applied the attached patch to HEAD and > REL8_0_STABLE that makes the securit