On Tue, Oct 10, 2006 at 02:22:53PM -0500, Richard Ray wrote: > I need to drop a superuser account. I get > > dba=# drop role bram; > ERROR: role "bram" cannot be dropped because some objects depend on it > DETAIL: owner of view teacher > owner of type teacher > owner of view temp1 > owner of type temp1 > ... > > What is the preferred method. You need to reassign ownership of those objects to someone else. -- Jim Nasby jim@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
