Re: BUG #2143: Indexes incorrectly created from database dump - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #2143: Indexes incorrectly created from database dump
Date
Msg-id 2717.1136387646@sss.pgh.pa.us
Whole thread Raw
In response to BUG #2143: Indexes incorrectly created from database dump  ("Robert Osowiecki" <robson@cavern.pl>)
Responses Re: BUG #2143: Indexes incorrectly created from database dump
List pgsql-bugs
"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?
What is the datatype of ar_code?  If it's a string type, what locale and
encoding are you using?  You have not given nearly enough information to
let anyone else reproduce the problem.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: BUG #2143: Indexes incorrectly created from database dump
Next
From: Brian Hirt
Date:
Subject: autovacuum process (PID ...) was terminated by signal 11