Re: partially effective revoke on pg_catalog

hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> On Mon, Sep 10, 2007 at 10:38:34AM -0400, Tom Lane wrote:
>> hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
>>> # revoke usage on schema pg_catalog from public;
>>> REVOKE
>> This is not a supported operation.

> ok, but i belive it should either dont allow admin to do so, or, if it
> does allow, it should behave more consistently.

There are few "training wheels" for superuser mode. Try something like
"delete from pg_proc" if you are looking for ways to break your
database.

regards, tom lane