Skip site navigation (1) Skip section navigation (2)

Re: Queries seem to lock up shell session

From: travep <traveppost(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Queries seem to lock up shell session
Date: 2001-08-19 18:09:34
Message-ID: 20010819180934.17427.qmail@web20208.mail.yahoo.com (view raw or flat)
Thread:
Lists: 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(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/

In response to

pgsql-novice by date

Next:From: Tom RobinsonDate: 2001-08-19 19:16:21
Subject: Re: How to find size of a table
Previous:From: Horst HerbDate: 2001-08-19 13:20:06
Subject: Re: how to use record type

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group