Hi On Mon, 2006-04-24 at 23:07 -0400, Alvaro Herrera wrote: > Gevik Babakhani wrote: > > > If one is going to revoke the last ACL_CONNECT, a warning is going to > > issued then that part of the REVOKE gets canceled. > > Humm, no, the WARNING is issued but the REVOKE is executed anyway.
I have tested this by applying the patch-0.4.diff of a new src tree. [EMAIL PROTECTED] ~]$ createdb CREATE DATABASE [EMAIL PROTECTED] ~]$ psql Welcome to psql 8.2devel, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit gevik=# revoke connection on database gevik from gevik; REVOKE gevik=# revoke connection on database gevik from public; WARNING: The revoke statement or at least one part of it cannot be completed on database gevik DETAIL: At least one database connection privilege should be granted for this database REVOKE gevik=# select datname,datacl from pg_catalog.pg_database; datname | datacl -----------+---------------------------- postgres | gevik | {=Tc/gevik,gevik=CT/gevik} template1 | {=c/gevik,gevik=CTc/gevik} template0 | {=c/gevik,gevik=CTc/gevik} (4 rows) gevik=# ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster