Re: [pgadmin-support] pgAgent and pgpass

2010-04-27 Thread Dave Page
On Tue, Apr 27, 2010 at 4:19 PM, Barry Schatz wrote: > I didn't receive a copy of my post from yesterday so I'm having to write > this as if it were a new post rather than a follow-up (keeping same subject > line). Gmail hides it for you. > FYI: I overcame the problem of pgAgent not reading .pgp

[pgadmin-support] pgAgent and pgpass

2010-04-27 Thread Barry Schatz
I didn't receive a copy of my post from yesterday so I'm having to write this as if it were a new post rather than a follow-up (keeping same subject line). FYI: I overcame the problem of pgAgent not reading .pgpass by eliminating the host address from the arguments, thus: DAEMON_ARGS="-l 1 -s /va

Re: [pgadmin-support] revoke select right on pg_proc

2010-04-27 Thread Guillaume Lelarge
Le 27/04/2010 15:50, Quan Zongliang a écrit : > in fact, that guy should not list anything in pgAdmin? > he said he can list views. it is weird. > > in my test, i can select data in psql from tables that select right > has been granted. but I can't list and object in pgAdmin. > You can surely do

Re: [pgadmin-support] revoke select right on pg_proc

2010-04-27 Thread Quan Zongliang
in fact, that guy should not list anything in pgAdmin? he said he can list views. it is weird. in my test, i can select data in psql from tables that select right has been granted. but I can't list and object in pgAdmin. On Tue, 27 Apr 2010 21:35:26 +0800 Quan Zongliang wrote: > Hi, all > > so

[pgadmin-support] revoke select right on pg_proc

2010-04-27 Thread Quan Zongliang
Hi, all someone said, his project needs to revoke select right from pg_proc: REVOKE SELECT ON pg_catalog.pg_proc FROM PUBLIC; Then pgAdmin can't list any table nodes and report a permission error. Because pgTableFactory::CreateObjects references to pg_proc, but can not access it. This is a abn