Re: BUG #1197: index bug - Mailing list pgsql-bugs

From Markus Bertheau
Subject Re: BUG #1197: index bug
Date
Msg-id 1090569928.3241.6.camel@dicaprio.akademie1.de
Whole thread Raw
In response to BUG #1197: index bug  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
=D0=92 =D0=92=D1=82=D1=80, 20.07.2004, =D0=B2 16:52, PostgreSQL Bugs List =
=D0=BF=D0=B8=D1=88=D0=B5=D1=82:
> I have DB under UTF8. A field of my table have btree index. But this inde=
x=20
> works incorrectly if this field content localized data. For example, how =
you=20
> can explain this:=20
>=20
> select object_id, name from main_objects where name=3D'=D0=9C=D0=B5=D0=B1=
=D0=B5=D0=BB=D1=8C';=20
>=20
> And I recieve the felouwing result set:
>=20
> object_id    name
> 185          =D0=9C=D0=B5=D0=B1=D0=B5=D0=BB=D1=8C
> 574          =D0=9C=D0=BE=D0=B4=D0=B5=D0=BC=D1=8B

I cannot reproduce this. Can you give a self-contained reproducible
example? What is the output of pg_controldata $PGDATA?

--=20
Markus Bertheau <twanger@bluetwanger.de>

pgsql-bugs by date:

Previous
From: Luke McFarlane
Date:
Subject: Re: ecpg -D SYMBOL
Next
From: Markus Bertheau
Date:
Subject: reproducible bug in I don't know what component