hi Craig, I think this thread could help you:
http://stackoverflow.com/questions/5408156/how-to-drop-a-postgresql-database-if-there-are-active-connections-to-it Sent from Samsung Mobile <div>-------- Original message --------</div><div>From: Craig Libscomb <[email protected]> </div><div>Date:04-22-2014 15:47 (GMT-05:00) </div><div>To: [email protected] </div><div>Subject: [GENERAL] Can't delete role because of unknown object </div><div> </div>The following command: DROP USER IF EXISTS jpate; generates the following output: ERROR: role "jpate" cannot be dropped because some objects depend on it DETAIL: 1 object in database products It would be most helpful to know what object in the products database depends on the jpate role, but I am unable to find anything that even begins to offer a clue. What command will show me this mysterious object, please? Thanks, Craig
