OK, the previous problem went away, but I can still do something like that:
postgres=# create role test; CREATE ROLE postgres=# create role test2; CREATE ROLE postgres=# create database db; CREATE DATABASE postgres=# \c db psql (8.5devel) You are now connected to database "db". db=# alter default privileges for role test2 grant insert on table to test; ALTER DEFAULT PRIVILEGES db=# \c postgres psql (8.5devel) You are now connected to database "postgres". postgres=# drop role test2; DROP ROLE postgres=# \c db psql (8.5devel) You are now connected to database "db". db=# select * from pg_default_acls ; defaclrole | defaclnamespace | defaclobjtype | defacllist ------------+-----------------+---------------+-------------------------------------- 16385 | 0 | r | {16385=arwdDxt/16385,test=a/wulczer} (1 row) db=# Dependencies suck, I know.. Jan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers