X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AB6615667D for ; Sat, 26 Feb 2005 17:54:07 +0000 (GMT) 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 21419-10 for ; Sat, 26 Feb 2005 17:53:58 +0000 (GMT) Received: from svr2.postgresql.org (unknown [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 21C9856654 for ; Sat, 26 Feb 2005 17:54:04 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.206]) by svr2.postgresql.org (Postfix) with ESMTP id 16EA0F0B26 for ; Sat, 26 Feb 2005 14:38:56 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 68so619123wri for ; Sat, 26 Feb 2005 06:40:35 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=BHFhBcLCwL2/V4+EK8lh7W3NtEaA8bVyN7hZwo1AbyAl5jGCDuLfgCRJ6t7o5vrnc/mdn6XrLx60bW1gDQjt2dw5X37jNoltW6C22yDvp5am00vda+gknOt1Vjk+1w2o1OehD9uPuw0FWnD6W8ICLwp1C3fexEhks+IPLdI12dQ= Received: by 10.54.23.51 with SMTP id 51mr128971wrw; Sat, 26 Feb 2005 06:40:35 -0800 (PST) Received: by 10.54.40.4 with HTTP; Sat, 26 Feb 2005 06:40:34 -0800 (PST) Message-ID: <621eda8a05022606404909b8d1@mail.gmail.com> Date: Sat, 26 Feb 2005 15:40:34 +0100 From: Zouari Fourat Reply-To: Zouari Fourat To: pgsql-admin@postgresql.org Subject: is it a bug or it's my mistake ? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/315 X-Sequence-Number: 16483 Hello, When selecting (from php) using this select : SELECT msgid,content,timecreated,soa FROM sms_mo WHERE (LOWER(content) LIKE 'club%') AND (da='87000') AND (timecreated > '2005-02-18 17:00:00') ORDER BY msgid ASC I get this error : PANIQUE: ERRORDATA_STACK_SIZE exceeded server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. when applying that select into phppgadmin interface there's no error. but when commenting the line : #client_encoding = LATIN9 in /var/lib/pgsql/data/postgresql.conf i will no longer have an error... but got problems with charsets (i use frensh accents and arab characters)