| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, schmidtm <schmidtm(at)mock-software(dot)de>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: somebody working on: Prevent default re-use of sysids |
| Date: | 2004-12-04 02:29:05 |
| Message-ID: | 200412040229.iB42T5521945@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2004-12-04 02:34:20 | Re: --prefix="/Program\ Files" and build failures |
| Previous Message | Tom Lane | 2004-12-04 01:43:45 | Re: --prefix="/Program\ Files" and build failures |