From: John Mulkerin <jmulkerin@comcast.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Intermittent Empty return
Date: Sat, 22 Sep 2007 15:09:04 -0700
Message-ID: <46F59280.7050809@comcast.net> (raw)
In-Reply-To: <3838.1190493672@sss.pgh.pa.us>
References: <46F57BBC.8070008@comcast.net>
<3838.1190493672@sss.pgh.pa.us>
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?
Tom Lane wrote:
> John Mulkerin <jmulkerin@comcast.net> writes:
>
>> I'm new to Postgres. I'm trying to select data from my survey_results
>> table. My server is running Postgres 7.3.4.
>>
>
> Do you realize how ancient that version is? An update would be a
> real good idea.
>
>
>> I log in as root (its RH), then
>> psql database_name. Its says "Welcome..... ". I then type "SELECT *
>> from survey_results" and hit enter. Nothing! It just goes back to the
>> database_name prompt.
>>
>
> It sounds like you've forgotten to end the command with a semicolon.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
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, tgl@sss.pgh.pa.us
Subject: Re: Intermittent Empty return
In-Reply-To: <46F59280.7050809@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