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
