psql overwrites command line

Поиск
Список
Период
Сортировка
От Malik Rumi
Тема psql overwrites command line
Дата
Msg-id CAKd6oByHO0Fw20NK-Sjju_BHi5BEMwRV4+hXQwisCNC0MM+SiA@mail.gmail.com
обсуждение исходный текст
Ответы Re: psql overwrites command line
Список pgsql-novice
Дерево обсуждения
I am working my way through the tutorial in the official docs. I am on Ubuntu 14.04 (Unity).

Twice I have had a series of tildes, one per line, show up after a command is executed, followed by END. The cursor is blinking at END, but there is no command prompt. I did \q and then the command prompt re-appeared, but the command before it, and the result, vanished.

Now I am also getting a situation where the cursor does not go to a newline while writing out commands, and instead starts overwriting the existing command from the beginning:

--
her.datSELECT weather.city, weather.temp_lo, weather.temp_hi, weather.prcp, weat
--

Then I am also getting scattered pieces of the commands within the results, like this:


--
mydb=# SELECT * FROM weather, cities WHERE city = name;
WHERE city =name;
     city      | temp_lo | temp_hi | prcp |    date    | location 
---------------+---------+---------+------+------------+-----------
 San Francisco |      46 |      50 | 0.25 | 1994-11-27 | (-194,53)
 San Francisco |      43 |      57 |    0 | 1994-11-29 | (-194,53)
(2 rows)
                                                                               ;
     city      | temp_lo | temp_hi | prcp |    date    | location  weather.city;
---------------+---------+---------+------+------------+-----------
 San Francisco |      46 |      50 | 0.25 | 1994-11-27 | (-194,53)
 San Francisco |      43 |      57 |    0 | 1994-11-29 | (-194,53)
(2 rows)
--

Note the extraneous semi colon above the location in the second table, as well as the extraneous weather.city; and the duplicated WHERE city =name; in the first table.

Can someone tell me a) what is going on here and b) how to fix it? Thanks.

В списке pgsql-novice по дате отправления: