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

Re: Queries seem to lock up shell session

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: travep <traveppost(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Queries seem to lock up shell session
Date: 2001-08-16 22:55:42
Message-ID: 26222.998002542@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Jeff EckermannDate: 2001-08-17 14:18:10
Subject: Re: how to use record type
Previous:From: Horst HerbDate: 2001-08-16 22:24:51
Subject: Fwd: [SQL] how to use record type

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