Postgres Pro
Downloads
Home   >   mailing lists

Thread: Queries seem to lock up shell session

Queries seem to lock up shell session

From
travep
Date:
I have installed Cygwin/PostgresSQL on a Win2000
machine and things seem to be operating correctly
except for one thing.  When I try to run a query from
the command prompt, the results are returned (after
much blank space) just before the word END.  Nothing I
do at this point seems to have any effect on the
system.  I cannot ctl-C out and eventually have to
shut down the shell.  I am able to create a DB, create
a table in that DB and insert data at will, it would
seem.  As soon as I try to see the data, I get the
above result.  What have I done wrong?

Thanks!
Travis

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/

Re: Queries seem to lock up shell session

From
Tom Lane
Date:
travep <traveppost@yahoo.com> writes:
> I have installed Cygwin/PostgresSQL on a Win2000
> machine and things seem to be operating correctly
> except for one thing.  When I try to run a query from
> the command prompt, the results are returned (after
> much blank space) just before the word END.  Nothing I
> do at this point seems to have any effect on the
> system.  I cannot ctl-C out and eventually have to
> shut down the shell.  I am able to create a DB, create
> a table in that DB and insert data at will, it would
> seem.  As soon as I try to see the data, I get the
> above result.  What have I done wrong?

Hmm, it seems like your pager ('less' or 'more', most likely)
is stuck.  Have you tried just pressing RETURN, or perhaps Q,
at the end of the query output?  I'm not sure why it wouldn't
respond to ^C though.  Worst-case, you could tell psql not to
use a pager program.

            regards, tom lane

Re: Queries seem to lock up shell session

From
travep
Date:
Your suggestion to just use 'Q' to release seems to
work.  Still do not know why ctl-C would not work.
Just thought I'd post in case others had similar
probs.

Travis

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> travep <traveppost@yahoo.com> writes:
> > I have installed Cygwin/PostgresSQL on a Win2000
> > machine and things seem to be operating correctly
> > except for one thing.  When I try to run a query
> from
> > the command prompt, the results are returned
> (after
> > much blank space) just before the word END.
> Nothing I
> > do at this point seems to have any effect on the
> > system.  I cannot ctl-C out and eventually have to
> > shut down the shell.  I am able to create a DB,
> create
> > a table in that DB and insert data at will, it
> would
> > seem.  As soon as I try to see the data, I get the
> > above result.  What have I done wrong?
>
> Hmm, it seems like your pager ('less' or 'more',
> most likely)
> is stuck.  Have you tried just pressing RETURN, or
> perhaps Q,
> at the end of the query output?  I'm not sure why it
> wouldn't
> respond to ^C though.  Worst-case, you could tell
> psql not to
> use a pager program.
>
>             regards, tom lane


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/