Few minor things... 1. DROP OWNED BY does not drop databases owned by the role. Should it? I would say not. This causes this strangeness
postgres=# drop owned by fred; DROP OWNED postgres=# drop user fred; ERROR: role "fred" cannot be dropped because some objects depend on it DETAIL: access to database fred Now I can see the detail "access to database fred" but its not completely clear that this means "fred still owns database fred". 2. REASSIGN OWNED BY cannot be executed by the role that is being reassigned. It throws ERROR: permission denied to reassign objects It seems strange that you can GRANT a priv to another user, yet you cannot REASSIGN ownership. 3. CREATE DATABASE syntax is OWNER = x. We might wish to deprecate that (but not remove it) and add OWNED BY x to make the "OWNED BY" phrase work in all places that need owners. -- Simon Riggs www.2ndQuadrant.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
