Re: dropping a user causes pain (#2)

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: dropping a user causes pain (#2)
Date: 2003-08-11 16:55:51
Message-ID: 3F37CA97.1030902@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message elein 2003-08-11 17:07:40 Re: Windows on SuSE? 7.4
Previous Message Josh Berkus 2003-08-11 16:29:01 Re: Farewell