Re: dropping a user causes pain (#2) - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: dropping a user causes pain (#2)
Date
Msg-id 3F37CA97.1030902@dunslane.net
Whole thread Raw
In response to Re: dropping a user causes pain (#2)  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-hackers
Andreas Pflug wrote:

> Dropping a user could merely set a "dropped" flag to disable login, 
> and some VACUUM action could cleanup databases.
>
How would you know when everything was cleaned up on all the databases?

A quick perusal of dev docs suggests that cleanup would need to take 
place in the following:

pg_am
pg_class
pg_conversion
pg_group
pg_namespace
pg_opclass
pg_operator
pg_proc (and watch for prosecdef)
pg_type

cheers

andrew



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Farewell
Next
From: Tom Lane
Date:
Subject: Re: dropping a user causes pain (#2)