> > I also tried hacking the search path and putting a pg_proc table
into
> > the public schema. While this fixed select * from pg_proc
> > (but not /df),
> > pgAdmin still pulled the function source.
>
> Odd - it didn't here. Every query on pg_proc resulted in a message box
> telling me it couldn't select from pg_proc - protecting the source,
but
> breaking pgAdmin.
What did you do exactly? Here's what I tried:
H:\>psql -h 205.217.85.89 test
test=# create user test;
CREATE USER
test=# revoke select on pg_proc from test;
REVOKE
test=# \q
H:\>psql -h 205.217.85.89 -U test test
test=> select * from pg_proc;
proname | pronamespace | proowner | prolan
isstrict | proretset | provolatile | pronargs | prorettype |
| proargnames |
[...]