Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

Hi,

On Sat, 1 Oct 2005, Tom Lane wrote:

>>> So yeah, ILIKE looks just about completely broken for multibyte encodings.
>>> The regexp code doesn't look better, btw, just differently broken ...
>
>> So any chance to fix it before beta 3 (and also backpatch?) ?
>
> Are you volunteering?
>
> This stuff has never worked, so I don't feel that it qualifies as "must
> fix for 8.1". If you can come up with a believable low-impact patch,
> I'd support putting it in now ... but my guess is that this is a
> significant bit of work that will not get done in this release cycle.

Yeah, I and Nicolai Tufar volunteer to fix it.

Regards,
--
Devrim GUNDUZ
Kivi Bilişim Teknolojileri - http://www.kivi.com.tr
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org
>From pgsql-bugs-owner(at)postgresql(dot)org Wed Oct 5 01:03:14 2005
X-Original-To: pgsql-bugs-postgresql(dot)org(at)localhost(dot)postgresql(dot)org
Received: from localhost (av.hub.org [200.46.204.144])
by svr1.postgresql.org (Postfix) with ESMTP id A133FD8ED3
for <pgsql-bugs-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 5 Oct 2005 01:03:13 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
with ESMTP id 06112-04
for <pgsql-bugs-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 5 Oct 2005 04:03:11 +0000 (GMT)
Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2])
by svr1.postgresql.org (Postfix) with ESMTP id 6452CD7FE7
for <pgsql-bugs(at)postgresql(dot)org>; Wed, 5 Oct 2005 01:03:11 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
id CD3F331059; Wed, 5 Oct 2005 06:03:10 +0200 (MET DST)
From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
X-Newsgroups: pgsql.bugs
Subject: Re: Possibly corrupted shared memory, PostgreSQL 8.1 beta2, Windows 2000
Date: Wed, 5 Oct 2005 00:03:10 -0700
Organization: Hub.Org Networking Services
Lines: 31
Message-ID: <dhvj9t$hel$1(at)news(dot)hub(dot)org>
References: <00b401c5c900$13abb410$6401a8c0(at)JP>
X-Complaints-To: usenet(at)news(dot)hub(dot)org
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
To: pgsql-bugs(at)postgresql(dot)org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.19 required=5 tests=[AWL=0.005,
PRIORITY_NO_NAME=1.185]
X-Spam-Level: *
X-Archive-Number: 200510/43
X-Sequence-Number: 13024

""Jean-Pierre Pelletier"" <pelletier_32(at)sympatico(dot)ca> wrote
>
> I've installed PostgreSQL 8.1 beta2 five days ago and it crashed 3 times
> since then.
> Here is what's been logged for the last crash
>
> 2005-10-04 11:00:19 FATAL: could not read block 121 of relation
> 1663/16384/2608: Invalid argument
>
> relation 2608 is pg_depend
> ----------------------------------------------------------------------------------
> The crash before that was on relation pg_type, the first line logged was:
> 2005-10-03 10:51:06 FATAL: could not read block 38 of relation
> 1663/16384/1247: Invalid argument
> ----------------------------------------------------------------------------------
> The first crash was also on relation pg_depend, but with open instead or
> read
> 2005-09-30 18:38:53 FATAL: could not open relation 1663/16384/2608:
> Invalid argument
> ----------------------------------------------------------------------------------
>

This problem was reported several times before, but not necessarily system
tables. Is there any anti-virus softwares installed on the same machine? Is
the database under intensive IO pressure?

Regards,
Qingqing