Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4168C475AF8 for ; Mon, 27 Jan 2003 08:29:15 -0500 (EST) Received: from callisto.Azimutec.com (unknown [195.15.58.241]) by postgresql.org (Postfix) with ESMTP id 90AAB47580B for ; Mon, 27 Jan 2003 08:29:13 -0500 (EST) Received: from IRANCY ([172.22.1.41]) by callisto.Azimutec.com with Microsoft SMTPSVC(5.0.2195.5329); Mon, 27 Jan 2003 14:36:50 +0100 From: "Samuel Torton" To: Subject: Probleme with Postgresql and phpPgAdmin on a Debian Linux Date: Mon, 27 Jan 2003 14:29:15 +0100 Organization: [http://www.ncslab.com] Message-ID: <000001c2c608$16a16870$290116ac@IRANCY> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-OriginalArrivalTime: 27 Jan 2003 13:36:50.0694 (UTC) FILETIME=[258F2A60:01C2C609] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/71 X-Sequence-Number: 1816 Hi, I'm having problem with Postgresql and phpPgAdmin on my Debian Linux box: - Debian Woody 3.0 - PostgreSQL 7.2.1 - phpPgAdmin 2.4.1 If I want to run a SQL from phpPgAdmin interface, such as: ------ INSERT INTO content VALUES (1, '1 description', 'content_tpl1', 'content_tpl1.gif', 'Il s\'agit d\'une simple page avec du texte.
Vous n\'avez qu\'à rajouter la description dans l\'espace réservé à cet effet.'); ------ ... I get the following error message : ------ Warning: PostgreSQL query failed: ERROR: parser: parse error at or near "agit" in /usr/share/phppgadmin/db_readdump.php on line 33 Error - /usr/share/phppgadmin/db_readdump.php -- Line: 33 PostgreSQL said: ERROR: parser: parse error at or near "agit" Your query: INSERT INTO content VALUES (1, '1 description', 'content_tpl1', 'content_tpl1.gif', 'Il s'agit d'une simple page avec du texte.
Vous n'avez qu'à rajouter la description dans l'espace ré .... ------ This type of command lines (with "\'" strings) used to work successfully with previous versions of PostgreSQL 7.0.3 Would anybody have any idea to debug ? Thank you, -- Samuel Torton http://www.ncslab.com