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@postgresql.org  Wed Oct  5 01:03:14 2005
X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A133FD8ED3
	for <pgsql-bugs-postgresql.org@localhost.postgresql.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.org@localhost.postgresql.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@postgresql.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@cs.toronto.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@news.hub.org>
References: <00b401c5c900$13abb410$6401a8c0@JP>
X-Complaints-To: usenet@news.hub.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@postgresql.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@sympatico.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