The following bug has been logged online:
Bug reference: 1145
Logged by: Fabien Coelho
Email address: coelho@cri.ensmp.fr
PostgreSQL version: 7.5 Dev
Operating system: linux debian
Description: silent REVOKE failures
Details:
REVOKE fails silently.
It may be a feature, but if so it is not a good one.
The documentation does not say this is a feature.
-- calvin has no "grant" rights on database comics nor -- on schema public.
calvin@[local]:5432
comics=> REVOKE ALL ON SCHEMA public FROM calvin;
REVOKE
calvin@[local]:5432
comics=> SELECT * FROM pg_namespace WHERE nspname='public';
nspname | nspowner | nspacl
---------+----------+----------------------------------------------------
public | 1 | {postgres=U*C*/postgres,"groupeleves=U/postgres"}
(1 row)
The REVOKE failure should be reported.