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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
