The problem with checking ownership of objects before dropping users is that there's no way to check what objects depend on a user on another database. But what if this information is stored in a shared relation? Like pg_depend but only for shared objects.
-- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) "Someone said that it is at least an order of magnitude more work to do production software than a prototype. I think he is wrong by at least an order of magnitude." (Brian Kernighan) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings