X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id D7F469DC9D5 for ; Wed, 18 Jan 2006 04:00:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66574-01 for ; Wed, 18 Jan 2006 04:00:27 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id DDD6F9DC9C5 for ; Wed, 18 Jan 2006 04:00:24 -0400 (AST) Received: from bitoek.uni-bayreuth.de (bti0x1.bitoek.uni-bayreuth.de [132.180.112.2]) by svr4.postgresql.org (Postfix) with ESMTP id 2A7495AF0A7 for ; Wed, 18 Jan 2006 08:00:23 +0000 (GMT) Received: from [132.180.112.27] (bti0x027.bitoek.uni-bayreuth.de [132.180.112.27]) by bitoek.uni-bayreuth.de (8.13.3/8.12.7) with ESMTP id k0I809DE004422; Wed, 18 Jan 2006 09:00:09 +0100 Message-ID: <43CDF588.6040308@bayceer.uni-bayreuth.de> Date: Wed, 18 Jan 2006 09:00:08 +0100 From: Stefan Holzheu User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.7.12) Gecko/20050921 X-Accept-Language: de, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: like vs = References: <43BD30D4.1030202@bayceer.uni-bayreuth.de> <1239.1137042135@sss.pgh.pa.us> In-Reply-To: <1239.1137042135@sss.pgh.pa.us> X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.08 required=5 tests=[AWL=0.080] X-Spam-Score: 0.08 X-Spam-Level: X-Archive-Number: 200601/187 X-Sequence-Number: 20275 Tom Lane schrieb: > Stefan Holzheu writes: >>Other queries with the equal operator do match rows. Am I missing something? > >>Postgresql: 8.1.1 >>Fieldtype: text >>Database encoding: Latin9 > > What LC_COLLATE locale are you using? Your report looks a whole lot > like the recently identified problem with locales that think that some > not-bitwise-identical strings are "equal", as in this thread: > http://archives.postgresql.org/pgsql-general/2005-12/msg00740.php LC_COLLATE was POSIX > > If the same queries return sane results after doing set enable_indexscan > = off, then that's probably what the problem is. If so, updating to > 8.1.2 and REINDEXing should fix it. > You were right. Query works now. Thanks Stefan > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > -- ----------------------------- Dr. Stefan Holzheu Tel.: 0921/55-5720 Fax.: 0921/55-5709 BayCEER EDV und Datenbanken Universitaet Bayreuth D-95440 Bayreuth -----------------------------