pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedIntermittent Empty return
5+ messages / 3 participants
[nested] [flat]
* Intermittent Empty return
@ 2007-09-22 20:31 John Mulkerin <jmulkerin@comcast.net>
2007-09-22 20:41 ` Re: Intermittent Empty return Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: John Mulkerin @ 2007-09-22 20:31 UTC (permalink / raw)
To: pgsql-sql
I'm new to Postgres. I'm trying to select data from my survey_results
table. My server is running Postgres 7.3.4. 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.
Its like there is no data in the table and I know its there. I can see
it in the Cold Fusion admin screen and I've seen it before in sql. \du
reflects root being a superuser.\dp survey_results says root has arwdRxt
access privileges. It just seems that 95% of time I get nothing back.
Even if I type "SELECT * from trash", It returns nothing and I can't
find any table called trash.
I've searched the list archives but haven't found any solution to my
problem.
Can anyone suggest a fix?
John
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Intermittent Empty return
2007-09-22 20:31 Intermittent Empty return John Mulkerin <jmulkerin@comcast.net>
@ 2007-09-22 20:41 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-09-22 22:09 ` Re: Intermittent Empty return John Mulkerin <jmulkerin@comcast.net>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2007-09-22 20:41 UTC (permalink / raw)
To: John Mulkerin <jmulkerin@comcast.net>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Intermittent Empty return
2007-09-22 20:31 Intermittent Empty return John Mulkerin <jmulkerin@comcast.net>
2007-09-22 20:41 ` Re: Intermittent Empty return Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-09-22 22:09 ` John Mulkerin <jmulkerin@comcast.net>
2007-09-22 23:14 ` Re: Intermittent Empty return Scott Marlowe <scott.marlowe@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: John Mulkerin @ 2007-09-22 22:09 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Intermittent Empty return
2007-09-22 20:31 Intermittent Empty return John Mulkerin <jmulkerin@comcast.net>
2007-09-22 20:41 ` Re: Intermittent Empty return Tom Lane <tgl@sss.pgh.pa.us>
2007-09-22 22:09 ` Re: Intermittent Empty return John Mulkerin <jmulkerin@comcast.net>
@ 2007-09-22 23:14 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-09-23 14:29 ` Re: Intermittent Empty return John Mulkerin <jmulkerin@comcast.net>
0 siblings, 1 reply; 5+ messages in thread
From: Scott Marlowe @ 2007-09-22 23:14 UTC (permalink / raw)
To: John Mulkerin <jmulkerin@comcast.net>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql
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... :)
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Intermittent Empty return
2007-09-22 20:31 Intermittent Empty return John Mulkerin <jmulkerin@comcast.net>
2007-09-22 20:41 ` Re: Intermittent Empty return Tom Lane <tgl@sss.pgh.pa.us>
2007-09-22 22:09 ` Re: Intermittent Empty return John Mulkerin <jmulkerin@comcast.net>
2007-09-22 23:14 ` Re: Intermittent Empty return Scott Marlowe <scott.marlowe@gmail.com>
@ 2007-09-23 14:29 ` John Mulkerin <jmulkerin@comcast.net>
0 siblings, 0 replies; 5+ messages in thread
From: John Mulkerin @ 2007-09-23 14:29 UTC (permalink / raw)
To: Scott Marlowe <scott.marlowe@gmail.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql
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
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2007-09-23 14:29 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-22 20:31 Intermittent Empty return John Mulkerin <jmulkerin@comcast.net>
2007-09-22 20:41 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-09-22 22:09 ` John Mulkerin <jmulkerin@comcast.net>
2007-09-22 23:14 ` Scott Marlowe <scott.marlowe@gmail.com>
2007-09-23 14:29 ` John Mulkerin <jmulkerin@comcast.net>
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