Re: Queries seem to lock up shell session - Mailing list pgsql-novice

From travep
Subject Re: Queries seem to lock up shell session
Date
Msg-id 20010819180934.17427.qmail@web20208.mail.yahoo.com
Whole thread Raw
In response to Re: Queries seem to lock up shell session  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
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/

pgsql-novice by date:

Previous
From: Andrew McMillan
Date:
Subject: Re: sequence properties
Next
From: Tom Robinson
Date:
Subject: Re: How to find size of a table