Re: Should rolpassword be toastable?

Поиск
Список
Период
Сортировка
От Alexander Lakhin
Тема Re: Should rolpassword be toastable?
Дата
Msg-id 67793ae1-3adc-a6e0-0bb3-c23a28c0627a@gmail.com
обсуждение исходный текст
Ответ на Re: Should rolpassword be toastable?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
23.09.2023 17:39, Tom Lane wrote:
> I'm also now more than just slightly skeptical about whether
> pg_database should have a toast table.  Has anybody tried,
> say, storing a daticurules field wide enough to end up
> out-of-line?

I tried, but failed, because pg_database accessed in InitPostgres() before
assigning MyDatabaseId only via the function GetDatabaseTupleByOid(),
which doesn't unpack the database tuple.
Another access to a system catalog with unassigned MyDatabaseId might occur
in the has_privs_of_role() call, but pg_auth_members contains no toastable
attributes.
So for now only pg_authid is worthy of condemnation, AFAICS.

Best regards,
Alexander



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Should rolpassword be toastable?
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: nbtree's ScalarArrayOp array mark/restore code appears to be buggy