Received: from mx99.openu.ac.il (arbel.openu.ac.il [147.233.32.4]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA25378 for ; Wed, 30 Jun 1999 10:17:51 -0400 (EDT) (envelope-from herouth@oumail.openu.ac.il) Received: from talmon.openu.ac.il (talmon.openu.ac.il [147.233.32.11]) by mx99.openu.ac.il (Postfix) with ESMTP for id A04A94B575; Wed, 30 Jun 1999 17:17:47 +0300 (IDT) Received: from [147.233.159.109] (mac-herouth.pc.openu.ac.il) by talmon.openu.ac.il (Netscape Messaging Server 3.54) with ESMTP id AAAB0C; Wed, 30 Jun 1999 17:20:42 +0300 X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: <377A1C47.5E480EAB@alumni.caltech.edu> References: <199906291746.NAA20468@hub.org> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Wed, 30 Jun 1999 17:19:28 +0300 To: Thomas Lockhart , Kyle Bateman From: Herouth Maoz Subject: Re: [PORTS] Port Bug Report: parse error not detected on unterminated quote Cc: pgsql-ports@postgreSQL.org At 16:31 +0300 on 30/06/1999, Thomas Lockhart wrote: > And seems to be: > > postgres=> select * from mytable' where id = 1234; > postgres'> ' > postgres-> ; > ERROR: parser: parse error at or near "'" > postgres=> > > This is on a RH5.2 system with with the cvs distribution of Postgres > (rather than v6.5 exactly). But the parsing behavior should be the > same. I'm not sure what could be different in our installations... In psql, it will probably never be a problem, because it demands that you close the quotation mark (that "postgres'>" prompt). It doesn't send anything to the backend until you have closed the quotation and type \g or ';'. But what happens if the above query is sent through one of the other interfaces, like pqlib? Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma