Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A194C9F99F6 for ; Sun, 23 Sep 2007 11:30:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84061-04 for ; Sun, 23 Sep 2007 11:30:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from sccrmhc14.comcast.net (sccrmhc14.comcast.net [204.127.200.84]) by postgresql.org (Postfix) with ESMTP id BCC7B9F9A0C for ; Sun, 23 Sep 2007 11:30:18 -0300 (ADT) Received: from [192.168.1.102] (c-24-6-155-241.hsd1.ca.comcast.net[24.6.155.241]) by comcast.net (sccrmhc14) with ESMTP id <2007092314301601400spimbe>; Sun, 23 Sep 2007 14:30:17 +0000 Message-ID: <46F6783D.1050305@comcast.net> Date: Sun, 23 Sep 2007 07:29:17 -0700 From: John Mulkerin User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Scott Marlowe CC: Tom Lane , pgsql-sql@postgresql.org Subject: Re: Intermittent Empty return References: <46F57BBC.8070008@comcast.net> <3838.1190493672@sss.pgh.pa.us> <46F59280.7050809@comcast.net> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/145 X-Sequence-Number: 29358 Thanks a lot. Scott Marlowe wrote: > On 9/22/07, John Mulkerin wrote: > >> I agree its old. I'm working on the upgrade but first need to verify >> and then purge some data. >> >> I tried with and without a semicolon >> >> However, with a semicolon results in >> >> Just tried semicolon again.. First time resulted in results. Second >> time resulted in >> select * from survey_results; >> ERROR: parser: parse error at or near "select" at character 30. >> Maybe another reason I need to upgrade? >> > > That's because what it's doing it running this: > select * from table select * from table; > > i.e. it's seeing the first one you typed without the semicolon then > second one too. > > You'll notice the prompt looks like this; > > dbname => select * from table > dbname -> select * from table; > > notice the -> That means there's already something in the buffer. > > \r resets the buffer. Just try it with ONLY the semicolon and it'll work. > > and yeah, get to work on that upgrade... :) > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > >