Re: Support regular expressions with nondeterministic collations - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Support regular expressions with nondeterministic collations
Date
Msg-id 165622.1730211171@sss.pgh.pa.us
Whole thread Raw
In response to Re: Support regular expressions with nondeterministic collations  (Peter Eisentraut <peter@eisentraut.org>)
List pgsql-hackers
Peter Eisentraut <peter@eisentraut.org> writes:
> On 22.10.24 16:40, Tom Lane wrote:
>> Peter Eisentraut <peter@eisentraut.org> writes:
>>> In summary, this patch doesn't change any functionality that currently
>>> works.  It just removes one error message and lets regular expressions
>>> just run, independent of whether the collation is nondeterministic.

>> I kind of wonder if we really want to do this.  It adds no
>> functionality, and it forecloses the possibility of changing
>> the definition later.

> Btw., one end goal here is to be able to run with a nondeterministic 
> collation as the global locale.  So for example you could make the whole 
> system insensitive to Unicode normalization forms.  But if that 
> effectively globally disables regular expressions, then people will be 
> sad, and also most of psql breaks, and so on.  So some positive solution 
> here would be useful.

Sure, and I'll support this patch once we're sure that no better
functionality is possible.  I just want to look into whether the
SQL committee knows something we don't.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Replace current implementations in crypt() and gen_salt() to OpenSSL
Next
From: Tom Lane
Date:
Subject: Re: Remove useless casts to (void *)