Re: unicode searches failing that use % and LIKE operators

Thanks, Tom and Greg, for all your help. I agree that Redhat 9 is a bit
creaky and that we here should upgrade. In the meantime I will put together a
tiny test case that will reproduce the problem (at least on my platform).

Ben

In message <26870(dot)1193091184(at)sss(dot)pgh(dot)pa(dot)us> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
writes:
> Benjamin Weaver <benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk> writes:
> > I AM in fact running the db on Linux. Redhat 9. Are the encoding
parameters
> > wrong for Linux?
>
> Hmm ... RH 9 is awfully old. It's at least conceivable that you're
> getting bit by some glibc bug. However, if these are just plain LIKE
> calls and not ILIKE then I don't think that theory is very viable
> --- AFAICS the regular LIKE code doesn't depend on anything from the
> platform.
>
> A slightly more viable theory is that you're getting bit by a gcc bug.
> Did you build the Postgres executables in-house, and if not where did
> you get them from? It might be helpful if you'd show us the output
> of "pg_config".
>
> Again, if you could put together a self-contained test case (preferably
> a short psql script) it would be helpful so we could try the case on
> other machines. It's not at all clear at this point whether the bug
> is Postgres' fault or something about the underlying platform.
>
> regards, tom lane

--
Benjamin Weaver
Faculty Research Associate, Imaging Papyri Projects, Herculaneum Society,
Oxford
email: benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk
phone: (0)1865 610236