"Bulgrien, Kevin" <Kevin.Bulgrien@xxxxxxxxxxxx> writes: > psql 8.3.16 > I've done some searching of mailing list, etc., but have either not searched > the right way, or something. If anyone could throw a bone on this it would > be appreciated. I have no idea what the procedure is for figuring out how > to drop this role: > DROP ROLE myuser; > ERROR: role "myuser" cannot be dropped because some objects depend on it > DETAIL: 1 objects in database postgres Try the command while connected to the postgres database. It can't give you more detail than that from where you are, for lack of visibility into the other database's system catalogs. Also, read up on DROP OWNED BY. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
