I have changed the revoke part of the patch. This time no restrictions,
only a warning message about a possible lockout.
http://www.xs4all.nl/~gevik/patch/patch-0.6.diff
Tom, Alvaro,
Do you think this will be accepted?
----------------------------------------------------------------------
[gevik@voyager ~]$ createdb
CREATE DATABASE
[gevik@voyager ~]$ 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
orterminate with semicolon to execute query \q to quit
gevik=# select datname,datacl from pg_catalog.pg_database; datname | datacl
-----------+----------------------------postgres |gevik |template1 | {=c/gevik,gevik=CTc/gevik}template0 |
{=c/gevik,gevik=CTc/gevik}
(4 rows)
gevik=# revoke connection on database gevik from public;
REVOKE
gevik=# revoke connection on database gevik from gevik;
WARNING: This revoke statement removes the last database connection
privilege from database gevik.
DETAIL: Unless you have superuser privileges you could be locked out
from connecting to this database.
REVOKE
gevik=# select datname,datacl from pg_catalog.pg_database; datname | datacl
-----------+----------------------------postgres |template1 | {=c/gevik,gevik=CTc/gevik}template0 |
{=c/gevik,gevik=CTc/gevik}gevik | {=T/gevik,gevik=CT/gevik}