Re: [BUGS] index returns different output

2000-11-04 Thread Lamar Owen
Tom Lane wrote: > I seem to recall something about another internationalization config > file that might cause problems on RH6.2, particularly if you upgraded > from an earlier release instead of doing a cold install of 6.2. But > I'm not finding it in the archives right now. Anyone remember > s

Re: [BUGS] index returns different output

2000-11-04 Thread Tom Lane
Viktor Przebinda <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> What LOCALE setting do you run the postmaster in? > Output of the locale program is as follows: > LANG=en_US > LC_CTYPE="en_US" > LC_NUMERIC="en_US" > LC_TIME="en_US" > LC_COLLATE="en_US" > LC_MONETARY="en_US" > LC_MESSAGES="en_US

Re: [BUGS] index returns different output

2000-11-04 Thread Tom Lane
What LOCALE setting do you run the postmaster in? This looks like it might be the known problem with LIKE index optimization not coping very well with non-ASCII collation orders. (It tries, but if you have collation rules where multicharacter patterns are treated specially, it tends to do the wro

[BUGS] index returns different output

2000-11-04 Thread Viktor Przebinda
I have come across a query that produces different output depending on weather or not an index is imposed on the relation. I am using postgresql-7.0.2-2 installed as a binary from an rpm downloaded from the postgres site. My machine is an Intel dual PII 300 with 256MB of ram. The system runs Linux