X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 76E6F568B7 for ; Sat, 26 Feb 2005 19:51:16 +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 60642-07 for ; Sat, 26 Feb 2005 19:51:07 +0000 (GMT) Received: from svr2.postgresql.org (unknown [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id 3410356849 for ; Sat, 26 Feb 2005 19:50:50 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198]) by svr2.postgresql.org (Postfix) with ESMTP id 3FE98F0C06 for ; Sat, 26 Feb 2005 16:40:07 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 68so632433wri for ; Sat, 26 Feb 2005 08:41:46 -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=tYZUSJnK3iELsnjW+UhvBFbj9JUox3B2im/UK+hOG7puSd7ZBQQBOrVHShnnbh/t1SEYXAlnTSeFdETKzbnY9NmOvjpI9RRGunKfsgXpnybjXffLrKj27cFVqtt7WEo5jj9/G4mY4jnubpLoKb29jQcmt5DkbVI/BoBHgJxSpPs= Received: by 10.54.50.6 with SMTP id x6mr111860wrx; Sat, 26 Feb 2005 06:55:05 -0800 (PST) Received: by 10.54.40.4 with HTTP; Sat, 26 Feb 2005 06:55:05 -0800 (PST) Message-ID: <621eda8a05022606552dbeb680@mail.gmail.com> Date: Sat, 26 Feb 2005 15:55:05 +0100 From: Zouari Fourat Reply-To: Zouari Fourat To: pgsql-php@postgresql.org Subject: is it a bug or is it 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.004 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/35 X-Sequence-Number: 3009 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)