Re: somebody working on: Prevent default re-use of sysids for dropped users and groups? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: somebody working on: Prevent default re-use of sysids for dropped users and groups?
Date
Msg-id 17710.1102789152@sss.pgh.pa.us
Whole thread Raw
In response to Re: somebody working on: Prevent default re-use of sysids for dropped users and groups?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
Alvaro Herrera <alvherre@dcc.uchile.cl> writes:
> I have been working on the patch and it seems now it works as I
> originally intended it to: dropping users or tablespaces is disallowed
> unless they own or contain no object.  ACL's are not tracked; I'm still
> unsure if they should be.

If we fail to track ACL references then it will still be possible to
drop users/groups for which there exist references in the database.
Which more or less defeats the point AFAICS.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Checkpoint bugs?
Next
From: "Schoudel, Brian"
Date:
Subject: tuple properties out of TupleTableSlot