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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Robert Osowiecki" <robson(at)cavern(dot)pl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2143: Indexes incorrectly created from database dump
Date: 2006-01-04 15:14:06
Message-ID: 2717.1136387646@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Robert Osowiecki" <robson(at)cavern(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John Supplee 2006-01-04 15:16:38 BUG #2144: Domain NOT NULL constraints ignored in rules
Previous Message Jaime Casanova 2006-01-04 14:35:17 Re: BUG #2143: Indexes incorrectly created from database dump