Re: dropping a user causes pain (#2)

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?
>
>  
>