From: John Mulkerin <jmulkerin@comcast.net>
To: pgsql-sql@postgresql.org
Subject: Intermittent Empty return
Date: Sat, 22 Sep 2007 13:31:56 -0700
Message-ID: <46F57BBC.8070008@comcast.net> (raw)
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
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
Subject: Re: Intermittent Empty return
In-Reply-To: <46F57BBC.8070008@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