Re: Should rolpassword be toastable?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Should rolpassword be toastable?
Дата
Msg-id 1986859.1726756275@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Should rolpassword be toastable?  (Nathan Bossart <nathandbossart@gmail.com>)
Ответы Re: Should rolpassword be toastable?
Список pgsql-hackers
Nathan Bossart <nathandbossart@gmail.com> writes:
> Hm.  It does seem like there's little point in giving pg_authid a TOAST
> table, as rolpassword is the only varlena column, and it obviously has
> problems.  But wouldn't removing it just trade one unhelpful internal error
> when trying to log in for another when trying to add a really long password
> hash (which hopefully nobody is really trying to do in practice)?  I wonder
> if we could make this a little more user-friendly.

We could put an arbitrary limit (say, half of BLCKSZ) on the length of
passwords.

            regards, tom lane



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