On 23.06.22 20:21, Adrian Klaver wrote:
>> Not sure why that is necessary? Is seems this is low hanging fruit
>> that could dealt with by the equivalent of lower('en_US.UTF-8') =
>> lower('en_US.utf-8').
>
> Well that was clear as mud. My point was that I don't see why the end
> user should have to do this when it could be handled internally in the
> pg_restore code.
There are also cases where on one system the locale is spelled
xx_YY.UTF8 and on another xx_YY.UTF-8. If we start adjusting for case,
should we adjust for this as well? What other cases are there?
So this would need a bit more research.