Re: somebody working on: Prevent default re-use of sysids - Mailing list pgsql-hackers

From Kris Jurka
Subject Re: somebody working on: Prevent default re-use of sysids
Date
Msg-id Pine.BSO.4.56.0412031810210.568@leary.csoft.net
Whole thread Raw
In response to Re: somebody working on: Prevent default re-use of sysids for dropped users and groups?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: somebody working on: Prevent default re-use of sysids for dropped users and groups?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: somebody working on: Prevent default re-use of sysids  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers

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


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: rc1 packaged ...
Next
From: Tom Lane
Date:
Subject: Re: somebody working on: Prevent default re-use of sysids for dropped users and groups?