BUG #1145: silent REVOKE failures

The following bug has been logged online:

Bug reference: 1145
Logged by: Fabien Coelho

Email address: coelho(at)cri(dot)ensmp(dot)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(at)[local]:5432
comics=> REVOKE ALL ON SCHEMA public FROM calvin;
REVOKE

calvin(at)[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.