Re: Should rolpassword be toastable? - Mailing list pgsql-hackers

From Alexander Lakhin
Subject Re: Should rolpassword be toastable?
Date
Msg-id 67793ae1-3adc-a6e0-0bb3-c23a28c0627a@gmail.com
Whole thread Raw
In response to Re: Should rolpassword be toastable?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Should rolpassword be toastable?
Next
From: Peter Geoghegan
Date:
Subject: Re: nbtree's ScalarArrayOp array mark/restore code appears to be buggy