Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TCBYJ-0005tD-Tl for pgsql-sql@postgresql.org; Thu, 13 Sep 2012 15:42:04 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TCBYI-0007rd-CK for pgsql-sql@postgresql.org; Thu, 13 Sep 2012 15:42:03 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q8DFg1Ea007663; Thu, 13 Sep 2012 11:42:01 -0400 (EDT) From: Tom Lane To: "Sergio C." cc: "pgsql-sql@postgresql.org" Subject: Re: underscore pattern in a query doens't work In-reply-to: <1347548674.20163.YahooMailNeo@web29505.mail.ird.yahoo.com> References: <1347535420.27469.YahooMailNeo@web29502.mail.ird.yahoo.com> <26099.1347545981@sss.pgh.pa.us> <1347548674.20163.YahooMailNeo@web29505.mail.ird.yahoo.com> Comments: In-reply-to "Sergio C." message dated "Thu, 13 Sep 2012 16:04:34 +0100" Date: Thu, 13 Sep 2012 11:42:01 -0400 Message-ID: <7659.1347550921@sss.pgh.pa.us> X-Pg-Spam-Score: -2.4 (--) X-Archive-Number: 201209/36 X-Sequence-Number: 36838 "Sergio C." writes: > We started the cluster up with this command: > ./initdb -D /usr/local/postgre/data -E UTF8 -U sir That doesn't prove anything about the specific database where you're having the problem ... regards, tom lane