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.1193091184@sss.pgh.pa.us> Tom Lane <tgl@sss.pgh.pa.us>
writes:
> Benjamin Weaver <benjamin.weaver@classics.ox.ac.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.weaver@classics.ox.ac.uk
phone:  (0)1865 610236