Re: pg_upgrade not preserving comments on predefined roles

Поиск
Список
Период
Сортировка
От Chapman Flack
Тема Re: pg_upgrade not preserving comments on predefined roles
Дата
Msg-id 60948606.1030301@anastigmatix.net
обсуждение исходный текст
Ответ на Re: pg_upgrade not preserving comments on predefined roles  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 05/02/21 19:25, Tom Lane wrote:
> Chapman Flack <chap@anastigmatix.net> writes:
>> I've appended the comments we use for them at $work, anyway.
> 
> IMO these would have to be shortened quite a bit to be friendly for
> "\du+" displays.  I'm not against the concept though.

I'm certainly not wedded to the exact wording we used here.

That said, our particular reason for having them (the bgworker-produced
roles/memberships/permissions graphviz thing) is not meant just for the
eyes of technical staff, but also to be presentable to, say, compliance
folks coming around asking about security provisions. So making the
comments so terse they'd require expansion for such an audience
might kind of defeat that purpose.

In pg_proc there seem to be a handful of things with 80 to 90 character
comments and one (a statistics function) at 111. Could that be taken
for precedent as to reasonable length?

Regards,
-Chap



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

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: alter table set TABLE ACCESS METHOD
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: alter table set TABLE ACCESS METHOD