Re: BUG #2143: Indexes incorrectly created from database dump

Tom Lane napisa³(a):

>"Robert Osowiecki" <robson@cavern.pl> writes:
>
>
>>BUT when on "where ar_code = 'FOO'" unique_code_i index is used and query
>>returns NO ROWS!
>>
>>
>
>Could you be more specific?  Which values of 'FOO' does this happen for?
>
>
I haven't checked for everyone. I'll be doing another dump:restore soon
so I'll be able to check that.

>What is the datatype of ar_code?  If it's a string type, what locale
>
ar_code is varchar(20)

>and
>encoding are you using?
>
locale is pl_PL: at least it sorts polish letters correctly. Database
encoding set to LATIN2

> You have not given nearly enough information to
>let anyone else reproduce the problem.
>
>
I'll be happy to answer any future questions, this is a critical issue
for me.

Robson.