Makes sense, but I think DROP USER should also warn immediately if it detects the most common case (I imagine) where the user owns things in the current database.
andrew
Bruce Momjian wrote:
If people want to remove a user, I assume they don't want to keep old objects around.
How about if we created a script that goes through all the databases and reports items owned by a specific user, or orphaned items not owned by anyone?
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
