Excerpts from McGehee, Robert's message of lun ago 23 13:29:47 -0400 2010: > PostgreSQL developers, > I am unable to drop a role with presumably no object dependencies or > connection access on my PostgreSQL 8.4.2 installation (64-bit OSX). Any > help would be greatly appreciated as I've spent way too much time trying > to execute a simple command. > > > template1=# DROP ROLE a485099; > ERROR: role "a485099" cannot be dropped because some objects depend on > it > DETAIL: access to database template1 So what does \l say about template1? > template1=# REASSIGN OWNED BY a485099 TO postgres; > template1=# DROP OWNED BY a485099; IIRC neither REASSIGN OWNED nor DROP OWNED do anything about access to databases. -- Álvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
