Re: [HACKERS] Making the regression tests locale-proof

2002-05-12 Thread Peter Eisentraut
Tom Lane writes: > In practice we could perhaps use test data that doesn't hit any of the > special cases in the popular languages. But I wonder whether this would > not be shirking our responsibility as testers. Seems like if you avoid > exercising these kinds of cases, you avoid finding corne

Re: [HACKERS] Making the regression tests locale-proof

2002-05-10 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > HPUX's behaviour is broken, because in spanish LL (as well as CH) > stopped being a special symbol some five years ago (it used to be > treated as one collating element sorted after "L", so HPUX behaviour was > right then). Well, this is an old release

Re: [HACKERS] Making the regression tests locale-proof

2002-05-10 Thread Alvaro Herrera
Tom Lane escribió: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > The assumption here is that all locales will choose the same sort order as > > long as they're dealing only with the core 26 letters. > > Nope. For instance, on HPUX I get this sort order in English: [...] > because the Sp

Re: [HACKERS] Making the regression tests locale-proof

2002-05-10 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > For that purpose I have changed the permissions on these options to > USERSET. (I'm still debating making lc_messages SUSET, because otherwise > users can screw with admins by changing the language of the log output all > the time. Comments?) Hm.

Re: [HACKERS] Making the regression tests locale-proof

2002-05-10 Thread Hannu Krosing
On Sat, 2002-05-11 at 02:25, Peter Eisentraut wrote: > The remaining issue is the sort order. I think this can be solved for > practical purposes by creating two expected files for each affected test, > say char.out and char-locale.out. The regression test driver would try > the first one, if th

Re: [HACKERS] Making the regression tests locale-proof

2002-05-10 Thread Trond Eivind Glomsrød
Peter Eisentraut <[EMAIL PROTECTED]> writes: > The assumption here is that all locales will choose the same sort order as > long as they're dealing only with the core 26 letters. This does not have > to be true in theory, but I think it works for the vast majority of > practical cases. Not for

[HACKERS] Making the regression tests locale-proof

2002-05-10 Thread Peter Eisentraut
Since locale support is now enabled by default, it is desirable that the regression tests can pass if the clusters locale is not C. As a first step I have included the following statements in pg_regress right after the database is created: alter database "$dbname" set lc_messages to 'C'; alter d