Re: PSQL bug?

At Thu, 17 Mar 2022 11:38:30 +0100, Dominique Devienne <ddevienne(at)gmail(dot)com> wrote in
> Made a typo, using } instead of ) to test a weird table name, and got
> disconnected. Normal? --DD
>
> ddevienne=> create table "t |" ( id int};
> ddevienne(> );
> 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.

The last line "Attempting reset: Succeeded." means that the connection
is once disconnected before the second input line then reconnected by
the input.

Specifically I can reproduce the same result by the following steps.

> ddevienne=> create table "t |" ( id int};
$ pg_ctl restart
> ddevienne(> );
> 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.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center