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

From Tom Lane
Subject Re: Should rolpassword be toastable?
Date
Msg-id 1986859.1726756275@sss.pgh.pa.us
Whole thread Raw
In response to Re: Should rolpassword be toastable?  (Nathan Bossart <nathandbossart@gmail.com>)
Responses Re: Should rolpassword be toastable?
List 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 by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Should rolpassword be toastable?
Next
From: Michail Nikolaev
Date:
Subject: Re: Conflict Detection and Resolution