From: John Mulkerin <jmulkerin@comcast.net>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Intermittent Empty return
Date: Sun, 23 Sep 2007 07:29:17 -0700
Message-ID: <46F6783D.1050305@comcast.net> (raw)
In-Reply-To: <dcc563d10709221614k637a5d9cvf896524b38bb9f2f@mail.gmail.com>
References: <46F57BBC.8070008@comcast.net>
<3838.1190493672@sss.pgh.pa.us>
<46F59280.7050809@comcast.net>
<dcc563d10709221614k637a5d9cvf896524b38bb9f2f@mail.gmail.com>
Thanks a lot.
Scott Marlowe wrote:
> 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... :)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jmulkerin@comcast.net, scott.marlowe@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: Intermittent Empty return
In-Reply-To: <46F6783D.1050305@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox