Re: [BUGS] BUG #1931: ILIKE and LIKE fails on

Merhaba,

On Sun, 2 Oct 2005, ALİ ÇELİK wrote:

> 12 gündür bu problem üzerinde çalışıyoruz. Projem için Zeoslib
> kullanıyordum. Sorun onda diye zeos u altını üstüne getirdim. Araya başka
> işler girdi ve ara verdim. Siz yazınca benim tekrar aklıma geldi. Yaf
> PostgreSQL in böyle basit bir hataya düşebileceğini hiç düşünmemiştim :(
> Neyseki siz buldunuz da telef olmaktan kurtuldum.

Nicolai ile bunun üzerinde çalışacağız ama sanırım 8.1'e yetişmeyecek.
8.1.X'e yetişmesini ümit ediyoruz (gerçi 8.2 için de olabilir ama o geç
olur).

İlgi bilgi.
--
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-tr-genel-owner(at)postgresql(dot)org Tue Oct 4 18:51:23 2005
X-Original-To: pgsql-tr-genel-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 1B630DA0B3;
Tue, 4 Oct 2005 18:51:20 -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 90430-08; Tue, 4 Oct 2005 21:51:14 +0000 (GMT)
Received: from mail.kivi.com.tr (mail.kivi.com.tr [213.143.254.37])
by svr1.postgresql.org (Postfix) with ESMTP id 76C67DA0A9;
Tue, 4 Oct 2005 18:51:15 -0300 (ADT)
Received: by mail.kivi.com.tr (Postfix, from userid 1009)
id 4F366E81D6; Wed, 5 Oct 2005 00:50:49 +0300 (EEST)
Received: from localhost (localhost [127.0.0.1])
by mail.kivi.com.tr (Postfix) with ESMTP id 453D3E81CB;
Wed, 5 Oct 2005 00:50:49 +0300 (EEST)
Date: Wed, 5 Oct 2005 00:50:49 +0300 (EEST)
From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
X-X-Sender: devrim2(at)mail(dot)kivi(dot)com(dot)tr
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-tr-genel(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #1931: ILIKE and LIKE fails on Turkish locale
In-Reply-To: <29723(dot)1128222853(at)sss(dot)pgh(dot)pa(dot)us>
Message-ID: <Pine(dot)LNX(dot)4(dot)63(dot)0510021152490(dot)25019(at)mail(dot)kivi(dot)com(dot)tr>
References: <20051001153536(dot)6C9EBF0B6F(at)svr2(dot)postgresql(dot)org>
<9028(dot)1128184301(at)sss(dot)pgh(dot)pa(dot)us> <Pine(dot)LNX(dot)4(dot)63(dot)0510020336270(dot)25019(at)mail(dot)kivi(dot)com(dot)tr>
<29723(dot)1128222853(at)sss(dot)pgh(dot)pa(dot)us>
MIME-Version: 1.0
X-Kivi-MailScanner-Information: Please contact the ISP for more information
X-Kivi-MailScanner: Found to be clean
X-Kivi-MailScanner-From: devrim(at)gunduz(dot)org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level:
Content-Type: TEXT/PLAIN; CHARSET=iso-8859-9; FORMAT=flowed
Content-Transfer-Encoding: 8BIT
Content-ID: <Pine(dot)LNX(dot)4(dot)63(dot)0510050050171(dot)15246(at)mail(dot)kivi(dot)com(dot)tr>
X-Archive-Number: 2005101/9
X-Sequence-Number: 299

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-tr-genel-owner(at)postgresql(dot)org Tue Oct 4 19:00:35 2005
X-Original-To: pgsql-tr-genel-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 2737BDA09D
for <pgsql-tr-genel-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Tue, 4 Oct 2005 19:00:33 -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 97932-03
for <pgsql-tr-genel-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Tue, 4 Oct 2005 22:00:29 +0000 (GMT)
Received: from mail.kivi.com.tr (mail.kivi.com.tr [213.143.254.37])
by svr1.postgresql.org (Postfix) with ESMTP id 078FADA07E
for <pgsql-tr-genel(at)postgresql(dot)org>; Tue, 4 Oct 2005 19:00:29 -0300 (ADT)
Received: by mail.kivi.com.tr (Postfix, from userid 1009)
id F2998E81D6; Wed, 5 Oct 2005 01:00:02 +0300 (EEST)
Received: from localhost (localhost [127.0.0.1])
by mail.kivi.com.tr (Postfix) with ESMTP id E906EE81CB;
Wed, 5 Oct 2005 01:00:02 +0300 (EEST)
Date: Wed, 5 Oct 2005 01:00:02 +0300 (EEST)
From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
X-X-Sender: devrim2(at)mail(dot)kivi(dot)com(dot)tr
Reply-To: pgsql-tr-genel(at)postgresql(dot)org
To: =?iso-8859-9?Q?AL=DD_=C7EL=DDK?= <ali(at)verus(dot)com(dot)tr>
Cc: pgsql-tr-genel(at)postgresql(dot)org
Subject: Re: FreeBSD vs Linux
In-Reply-To: <dhoq15$1jat$1(at)news(dot)hub(dot)org>
Message-ID: <Pine(dot)LNX(dot)4(dot)63(dot)0510021739200(dot)25019(at)mail(dot)kivi(dot)com(dot)tr>
References: <dhoq15$1jat$1(at)news(dot)hub(dot)org>
MIME-Version: 1.0
X-Kivi-MailScanner-Information: Please contact the ISP for more information
X-Kivi-MailScanner: Found to be clean
X-Kivi-MailScanner-From: devrim(at)gunduz(dot)org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level:
Content-Type: TEXT/PLAIN; CHARSET=iso-8859-9; FORMAT=flowed
Content-Transfer-Encoding: 8BIT
Content-ID: <Pine(dot)LNX(dot)4(dot)63(dot)0510050052591(dot)15246(at)mail(dot)kivi(dot)com(dot)tr>
X-Archive-Number: 2005101/10
X-Sequence-Number: 300

Merhaba,

On Sun, 2 Oct 2005, ALİ ÇELİK wrote:

> PostgreSQL in Hangi platformda ne kadar başarım verdiği ile ilgili bir
> istatistik var mı?
>
> Linux,FreeBSD veya Win32 performansları nasıl?

Win32 sürümü henüz yeni sayılır. Her ne kadar içindeki büyük kod parçası
eski olsa da Windows üzerindeki kararlılık için bence biraz daha beklemek
gerekli. (Belki performans ile ilgili değil ama) Unicode vs desteği de 8.0
içinde yok (Windows sürümünde), bu nedenle tercih edilmez diye
düşünmekteyim.

FreeBSD ve Linux'a gelince...

Şimdi benim biri hariç tüm sunucularım Linux. FreeBSD olana yeni kurdum ve
yönetmeye başladım, o yüzden net bir karşılaştırma yapamayacağım.

Ancak, PostgreSQL.org sunucularının yönetiminden edindiğim tecrübeye
bakarsak, ikisi arasında birbirini " ezecek " kadar bir fark yok.

Ben RHEL ve SLES üzerinde deniyorum son zamanlarda. RHEL 3.0 üzerinde
ciddi bir sunucu çalışıyor:

[root(at)web pg_log]# ll
total 1367172
-rw------- 1 postgres postgres 184232379 Oct 1 00:00
postgresql-Fri.log
-rw------- 1 postgres postgres 334944335 Oct 4 00:00
postgresql-Mon.log
-rw------- 1 postgres postgres 193482214 Oct 1 23:59
postgresql-Sat.log
-rw------- 1 postgres postgres 164792772 Oct 2 23:59
postgresql-Sun.log
-rw------- 1 postgres postgres 376297934 Sep 29 23:59
postgresql-Thu.log
-rw------- 1 postgres postgres 143517880 Oct 5 00:00
postgresql-Tue.log
-rw------- 1 postgres postgres 1300505 Oct 5 00:57 postgresql-Wed.log

Sunucunun ürettiği "günlük" kayıtların büyüklüğüne bakarsanız yoğunluğu
tahmin edebilirsiniz. Bu sunucu 1 yıldan beri çalışıyor kesintisiz ve
gayet iyi bir durumda.

SLES üzerinde teknik testler kadar UNICODE testleri de başarılı. %100
bitiremedim testleri ama SLES de iyi bir alternatif olabilir.

Bu arada OSDL'de yapılan testlere de bir bakın. Orada 16-64 işlemcili
makinelerde PostgreSQL deniyorlar.

> adresine yollayabilirsiniz.

Her iletinin altına ekleniyor bu, nasil olduğunu bulursam mutlu olacağım
:(

--
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-tr-genel-owner(at)postgresql(dot)org Wed Oct 5 02:19:30 2005
X-Original-To: pgsql-tr-genel-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 CF7B8DA197
for <pgsql-tr-genel-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 5 Oct 2005 02:17:54 -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 68071-09
for <pgsql-tr-genel-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 5 Oct 2005 05:17:52 +0000 (GMT)
Received: from mail.kivi.com.tr (mail.kivi.com.tr [213.143.254.37])
by svr1.postgresql.org (Postfix) with ESMTP id 39659DA272
for <pgsql-tr-genel(at)postgresql(dot)org>; Wed, 5 Oct 2005 02:17:50 -0300 (ADT)
Received: by mail.kivi.com.tr (Postfix, from userid 1009)
id BAD3CE81D6; Wed, 5 Oct 2005 08:17:20 +0300 (EEST)
Received: from localhost (localhost [127.0.0.1])
by mail.kivi.com.tr (Postfix) with ESMTP id AE689E81CB;
Wed, 5 Oct 2005 08:17:20 +0300 (EEST)
Date: Wed, 5 Oct 2005 08:17:20 +0300 (EEST)
From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
X-X-Sender: devrim2(at)mail(dot)kivi(dot)com(dot)tr
To: pgsql-tr-genel(at)PostgreSQL(dot)org
Cc: linux-programlama(at)liste(dot)linux(dot)org(dot)tr
Subject: =?iso-8859-9?Q?Yeni_PostgreSQL_ara_s=FCr=FCmleri_duyuruldu=2E?=
Message-ID: <Pine(dot)LNX(dot)4(dot)63(dot)0510050816410(dot)20542(at)mail(dot)kivi(dot)com(dot)tr>
MIME-Version: 1.0
X-Kivi-MailScanner-Information: Please contact the ISP for more information
X-Kivi-MailScanner: Found to be clean
X-Kivi-MailScanner-From: devrim(at)gunduz(dot)org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006]
X-Spam-Level:
Content-Type: TEXT/PLAIN; charset=iso-8859-9; format=flowed
Content-Transfer-Encoding: 8BIT
X-Archive-Number: 2005101/11
X-Sequence-Number: 301

Merhaba,

Duyuru aşağıda:

---------- Forwarded message ----------
Date: Tue, 4 Oct 2005 20:15:16 -0300 (ADT)
From: Marc G. Fournier <scrappy(at)postgresql(dot)org>
To: pgsql-announce(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: [ANNOUNCE] New Point Releases Now Available

In order to address several issues identified since our last Point Releases,
we have just released the following new versions of PostgreSQL: 7.3.11, 7.4.9
and 8.0.4.

A few of the more prominent fixes across all three versions are:

- Fix error that allowed "VACUUM" to remove ctid chains too soon
- Fix missing rows in queries like UPDATE a=... WHERE a... with GiST
index on column a
- Improve checking for partially-written WAL pages
- Various memory leakage fixes

For a complete list of fixes in each release, please see the HISTORY file.

Source downloads are available at the following URLs:

http://www.postgresql.org/ftp/source/v7.3.11

http://www.postgresql.org/ftp/source/v7.4.9

http://www.postgresql.org/ftp/source/v8.0.4

Linux/Windows Binaries for 8.0.4 are available via:

http://www.postgresql.org/ftp/binary/v8.0.4

These Point Releases do not require a dump/reload from the previous Point,
but *may* require one if upgrading from an earlier version. Please see the
Release Notes to confirm procedures for upgrading if your current version is
older then 1 Point Release.

Marc G. Fournier
PostgreSQL Core Team

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
>From pgsql-tr-genel-owner(at)postgresql(dot)org Wed Oct 5 17:23:28 2005
X-Original-To: pgsql-tr-genel-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 E6910DA26F
for <pgsql-tr-genel-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Wed, 5 Oct 2005 17:23:25 -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 47443-05
for <pgsql-tr-genel-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Wed, 5 Oct 2005 20:23:18 +0000 (GMT)
Received: from mail.kivi.com.tr (mail.kivi.com.tr [213.143.254.37])
by svr1.postgresql.org (Postfix) with ESMTP id EFB1BDA215
for <pgsql-tr-genel(at)postgresql(dot)org>; Wed, 5 Oct 2005 17:23:15 -0300 (ADT)
Received: by mail.kivi.com.tr (Postfix, from userid 1009)
id 3DF3CE81D6; Wed, 5 Oct 2005 23:22:46 +0300 (EEST)
Received: from localhost (localhost [127.0.0.1])
by mail.kivi.com.tr (Postfix) with ESMTP id 3059AE81CB;
Wed, 5 Oct 2005 23:22:46 +0300 (EEST)
Date: Wed, 5 Oct 2005 23:22:46 +0300 (EEST)
From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
X-X-Sender: devrim2(at)mail(dot)kivi(dot)com(dot)tr
Reply-To: pgsql-tr-genel(at)PostgreSQL(dot)org
To: pgsql-tr-genel(at)PostgreSQL(dot)org
Cc: linux-programlama(at)liste(dot)linux(dot)org(dot)tr
Subject: =?iso-8859-9?Q?Sun_-_PostgreSQL_yak=FDnla=FEmas=FD?=
Message-ID: <Pine(dot)LNX(dot)4(dot)63(dot)0510052317430(dot)373(at)mail(dot)kivi(dot)com(dot)tr>
MIME-Version: 1.0
X-Kivi-MailScanner-Information: Please contact the ISP for more information
X-Kivi-MailScanner: Found to be clean
X-Kivi-MailScanner-From: devrim(at)gunduz(dot)org
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.005 required=5 tests=[AWL=0.005]
X-Spam-Level:
Content-Type: TEXT/PLAIN; CHARSET=iso-8859-9; FORMAT=flowed
Content-Transfer-Encoding: 8BIT
Content-ID: <Pine(dot)LNX(dot)4(dot)63(dot)0510052320301(dot)373(at)mail(dot)kivi(dot)com(dot)tr>
X-Archive-Number: 2005101/12
X-Sequence-Number: 302

Merhaba,

http://people.planetpostgresql.org/xzilla/index.php?/archives/91-Is-Sun-gettin
g-ready-to-join-the-PostgreSQL-community.html

http://www.computerworld.com.au/index.php/id;116679278;fp;16;fpid;0

http://developers.slashdot.org/developers/05/10/05/1344254.shtml?tid=221&tid=218

Saygılar.
--
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-tr-genel-owner(at)postgresql(dot)org Thu Oct 6 13:13:00 2005
X-Original-To: pgsql-tr-genel-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 F3F8BDA1C4
for <pgsql-tr-genel-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>; Thu, 6 Oct 2005 13:12:56 -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 78986-07
for <pgsql-tr-genel-postgresql(dot)org(at)localhost(dot)postgresql(dot)org>;
Thu, 6 Oct 2005 16:12:54 +0000 (GMT)
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2])
by svr1.postgresql.org (Postfix) with ESMTP id 37A7ADA108
for <pgsql-tr-genel(at)postgresql(dot)org>; Thu, 6 Oct 2005 13:12:49 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
id 9ED9A31059; Thu, 6 Oct 2005 18:12:48 +0200 (MET DST)
From: "ALİ ÇELİK" <ali(at)verus(dot)com(dot)tr>
X-Newsgroups: pgsql.tr.genel
Subject: Tek sorguyla birden fazla veritabanından bilgi çekmek
Date: Thu, 6 Oct 2005 19:12:43 +0300
Organization: Hub.Org Networking Services
Lines: 7
Message-ID: <di3idt$kf5$1(at)news(dot)hub(dot)org>
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.2670
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
To: pgsql-tr-genel(at)postgresql(dot)org
X-Virus-Scanned: by amavisd-new at hub.org
X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char DD hex) in message header 'From': From: "AL\335 \307EL\335K" <ali(at)ve(dot)(dot)(dot)
X-Spam-Status: No, hits=3.143 required=5 tests=[AWL=-0.896,
PRIORITY_NO_NAME=1.185, SUBJ_ILLEGAL_CHARS=2.854]
X-Spam-Level: ***
X-Archive-Number: 2005101/13
X-Sequence-Number: 303

Olabilir mi?

Hayırlı ramazanlar...

Ali ÇELİK