DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=m4+Qcj5WKO2lVL3N3q02oqnWj3+JMzBAdjp6Z1XkmepZNzkN5SctDmi9enlq7Qr+zXfGIYMkxVXyQWrXEs09d3siN+/1COSivpjV3ibATamIuKuzwvzSF+b6nN3Lo3YAeW/HEN3MotAIm1u4fc/yzWV4gZo63hzH6xysCZsRO8Y=
Message-ID: <dcc563d10709221614k637a5d9cvf896524b38bb9f2f@mail.gmail.com>
Date: Sat, 22 Sep 2007 18:14:14 -0500
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "John Mulkerin" <jmulkerin@comcast.net>
Subject: Re: Intermittent Empty return
Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, pgsql-sql@postgresql.org
In-Reply-To: <46F59280.7050809@comcast.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <46F57BBC.8070008@comcast.net> <3838.1190493672@sss.pgh.pa.us>
	<46F59280.7050809@comcast.net>

On 9/22/07, John Mulkerin <jmulkerin@comcast.net> 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... :)