Re: dropped users appear as numbers in ACL - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: dropped users appear as numbers in ACL
Date
Msg-id Pine.LNX.4.44.0311132154000.17499-100000@peter.localdomain
Whole thread Raw
In response to dropped users appear as numbers in ACL  (DHS Webmaster <webmaster@dhs-club.com>)
Responses Re: dropped users appear as numbers in ACL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
DHS Webmaster writes:

> I noticed this with groups in the past and have become accustomed to
> deleting these users from the groups before dropping them. Otherwise I
> had to create dummy users with those IDs, go about cleaning things out
> and then drop the dummy user.
> Will I have to perform this same procedure for ACLs?

Yes.

> Are there any plans to handle these issues transparently when a user is
> dropped?

"Wishlist" maybe, but no concrete plans.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-admin by date:

Previous
From: DHS Webmaster
Date:
Subject: dropped users appear as numbers in ACL
Next
From: Greg Spiegelberg
Date:
Subject: Moving Database Directory