"Andrus" <kobruleht2@xxxxxx> writes: >> This looks like a problem already reported, and patched here: >> http://archives.postgresql.org/pgsql-committers/2007-05/msg00088.php >> but that fix hasn't made it into any released version yet. > Thank you. > I fixed it in my application by changing index to upper() instead of lower : > CREATE UNIQUE INDEX toode_toode_unique_pattern_idx1 > ON firma1.toode > USING btree > (upper(toode::text) text_pattern_ops); > and using > SELECT * FROM firma1.toode WHERE upper(toode) LIKE 'Ä%' > Will this work OK ? I think you're probably just dodging one symptom by exposing yourself to others :-(. Maybe you will hit some other cases, or maybe not; there's not enough detail here to guess. We are overdue for another set of patch releases, but right now the core committee is trying to focus on pushing 8.3 to beta release readiness. I hope we can come up for air from that, and push out some back-branch updates, in the second half of August. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
