Re: dropping a user causes pain (#2)

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: dropping a user causes pain (#2)
Дата
Msg-id 3F37CA97.1030902@dunslane.net
обсуждение исходный текст
Ответ на Re: dropping a user causes pain (#2)  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Farewell
Следующее
От: Tom Lane
Дата:
Сообщение: Re: dropping a user causes pain (#2)