Re: Backpatching of "Teach the regular expression functions to do case-insensitive matching"

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org, Andrew Dunstan <andrew(at)dunslane(dot)net>
Subject: Re: Backpatching of "Teach the regular expression functions to do case-insensitive matching"
Date: 2011-05-10 19:12:37
Message-ID: 1305054757.17455.4.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On mån, 2011-05-09 at 12:42 -0400, Tom Lane wrote:
> The problem we'd have is that there's no way (at present) to make such
> a test pass on every platform. Windows has its own set of locale names
> (which initdb fails to install as collations anyway) and we also have
> the problem that OS X can be counted on to get UTF8 sorting wrong.
> (It might be okay for case-folding though; not sure.) Possibly we could
> just provide an alternate expected file for OS X, but I don't see a
> decent workaround for Windows --- it would pretty much have to have its
> very own test case.

Windows >=Vista has locale names similar to Linux, and my cursory
testing with some hacked up test suite indicates that it produces the
same results as the Linux expected file, modulo some error message
differences. So I think this could be made to work, it just needs
someone to implement a few bits.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-05-10 19:17:04 Re: Backpatching of "Teach the regular expression functions to do case-insensitive matching"
Previous Message Josh Berkus 2011-05-10 19:12:21 Re: Formatting Curmudgeons WAS: MMAP Buffers