psql command line client behaviour

Поиск
Список
Период
Сортировка
От Jiri Sadek
Тема psql command line client behaviour
Дата
Msg-id 4DC26F32.70409@gmail.com
обсуждение исходный текст
Ответы Re: psql command line client behaviour  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
I was told about behaviour of psql command line client that seems as bug
to me. When I am connected to server (cmdline client, interactive mode)
and server is restarted next query fails and client try to reconnect to
server. Problem arise when I send more queries (not speaking that this
may not be a good habit) at once - on first one client detects that
connection is lost and try to reconnect and then rest of queries are
executed (but not the first one). This can have bad consequences (e.g.
if first query is BEGIN;):

sample (postgresql 8.3.15):

(test@[local:/var/opt/testdb/pg_sockets]:20000) 10:55:34 [testdb]
#> select 10; select 20;
  ?column?
----------
        10
(1 row)

Time: 0.142 ms
  ?column?
----------
        20
(1 row)

Time: 0.039 ms
(test@[local:/var/opt/testdb/pg_sockets]:20000) 10:55:42 [testdb]
#> select 10; select 20;
FATAL:  terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
  ?column?
----------
        20
(1 row)

Time: 0.193 ms

I would suggest to not execute any query or all of them after reconnect.

Jiri

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

Предыдущее
От: Alex Hunsaker
Дата:
Сообщение: Re: Plperl trigger variables no longer global
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Plperl trigger variables no longer global