[ADMIN] How to remove a superuser

[Richard Ray]

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.

Thanks
Richard Ray

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match