Re: PSQL bug? - Mailing list pgsql-general

From Kyotaro Horiguchi
Subject Re: PSQL bug?
Date
Msg-id 20220318.095246.1002729492012335813.horikyota.ntt@gmail.com
Whole thread Raw
In response to PSQL bug?  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
At Thu, 17 Mar 2022 11:38:30 +0100, Dominique Devienne <ddevienne@gmail.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



pgsql-general by date:

Previous
From: Арсен Арутюнян
Date:
Subject: Re[5]: LISTEN/NOTIFY ultra slow speed
Next
From: Merlin Moncure
Date:
Subject: Re: How to explicitly lock and unlock tables in pgsql?