Re: psql does not provide proper response - Mailing list pgsql-general

From Bryn Llewellyn
Subject Re: psql does not provide proper response
Date
Msg-id 97C07E82-7E62-446A-B84C-ED158153F29E@yugabyte.com
Whole thread Raw
In response to psql does not provide proper response  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses Re: psql does not provide proper response
List pgsql-general
> shishaozhong@gmail.com wrote:
>
> I do not know what happened.
>
> psql does not provide proper response anymore.
>
> I typed the following and see nothing.
>
> user=# select * from boundaryline.scotland_and_wales_const_region
> user-#
>
> Can anyone enlighten me?

This happens to me all too frequently. Then I kick myself and realize that I earlier said “\o spool.txt” (by hand) and
forgotto turn it off with the bare “\o”. This is my typical use case: 

\o spool.txt
\i script.sql

The script causes an error. I read it, see the bad statement, and then type the correct statement by hand. Then I see
whatyou did: a big fat nothing. 

Might this be happening to you?




pgsql-general by date:

Previous
From: Garfield Lewis
Date:
Subject: Re: [EXT] Re: Can we get the CTID value
Next
From: "David G. Johnston"
Date:
Subject: Re: [EXT] Re: Can we get the CTID value