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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: 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 for dropped users and groups?
Date: 2004-12-11 18:19:12
Message-ID: 17710.1102789152@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-12-11 18:47:29 Re: tuple properties out of TupleTableSlot
Previous Message Simon Riggs 2004-12-11 17:36:30 Checkpoint bugs?