Re: dropped users appear as numbers in ACL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: dropped users appear as numbers in ACL
Дата
Msg-id 15006.1068767846@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: dropped users appear as numbers in ACL  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: dropped users appear as numbers in ACL  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-admin
Peter Eisentraut <peter_e@gmx.net> writes:
> DHS Webmaster writes:
>> Are there any plans to handle these issues transparently when a user is
>> dropped?

> "Wishlist" maybe, but no concrete plans.

The reason it's difficult is that users span databases; when you drop a
user in database A, you have no way of seeing/removing references to him
that exist in databases B, C, ...

I'm not sure there's any really good answer to this short of changing
the way that users and databases work, which so far no one has wanted
to do.

            regards, tom lane

В списке pgsql-admin по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_restore and FK constraints with large dbs
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: dropped users appear as numbers in ACL