Re: lower() and unaccent() not leakproof - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: lower() and unaccent() not leakproof
Date
Msg-id 7eb0e72c-d638-a223-858c-24ce29f1f2e8@enterprisedb.com
Whole thread Raw
In response to Re: lower() and unaccent() not leakproof  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: lower() and unaccent() not leakproof
List pgsql-general
On 26.08.21 16:00, Tom Lane wrote:
> Generally speaking, we've been resistant to marking anything leakproof
> unless it has a very small code footprint that can be easily audited.
> 
> In particular, anything that shares a lot of infrastructure with
> not-leakproof functions seems quite hazardous.  Even if you go through
> the code and convince yourself that it's OK today, innocent changes
> to the shared infrastructure could break the leakproofness tomorrow.

I think the complexity of the implementation of upper() and lower() is 
on the same order as bttextcmp() and similar, so it wouldn't be totally 
out of scope.




pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: lower() and unaccent() not leakproof
Next
From: Daniel Gustafsson
Date:
Subject: Re: lower() and unaccent() not leakproof