Re: somebody working on: Prevent default re-use of sysids

Kris Jurka wrote:
> 
> 
> 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

That is for allowing comments on global tables like pg_shadow and
pg_database.  I don't think it relates to finding if someone owns
objects in another database.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073