The following bug has been logged online:
Bug reference: 1145
Logged by: Fabien Coelho
Email address: [EMAIL PROTECTED]
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.
[EMAIL PROTECTED]:5432
comics=> REVOKE ALL ON SCHEMA public FROM calvin;
REVOKE
[EMAIL PROTECTED]: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.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
