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
