On Fri, 3 Dec 2004, Tom Lane wrote:
> > 2) Prevent dropping user that still owns objects, or auto-drop the
> > objects
>
> No one has any idea how to do this reasonably --- the problem is you
> have no visibility into databases other than the one you're connected
> to, so you can't tell what the user owns in other databases.
>
What about Alvaro's shared dependencies work:
http://archives.postgresql.org/pgsql-hackers/2004-10/msg00963.php
Kris Jurka