Re: Queries seem to lock up shell session

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> travep <traveppost(at)yahoo(dot)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/