Thread

1. Re: PSQL bug?

   Pavel Stehule <pavel.stehule@gmail.com> — 2022-03-17T10:38:16Z

   Hi
   
   čt 17. 3. 2022 v 11:35 odesílatel Dominique Devienne <ddevienne@gmail.com>
   napsal:
   
   > 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.
   > ddevienne=> create table "t |" ( id int);
   > ddevienne=> drop table "t |";
   > ddevienne=> \! psql -V
   > psql (PostgreSQL) 12.1
   > ddevienne=> select version();
   >                                                  version
   >
   > ---------------------------------------------------------------------------------------------------------
   >  PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
   > 20150623 (Red Hat 4.8.5-39), 64-bit
   > (1 row)
   >
   
   I don't see any problem on master
   

2. PSQL bug?

   Dominique Devienne <ddevienne@gmail.com> — 2022-03-17T10:38:30Z

   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.
   ddevienne=> create table "t |" ( id int);
   ddevienne=> drop table "t |";
   ddevienne=> \! psql -V
   psql (PostgreSQL) 12.1
   ddevienne=> select version();
                                                    version
   ---------------------------------------------------------------------------------------------------------
    PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
   20150623 (Red Hat 4.8.5-39), 64-bit
   (1 row)
   
   
   
   

3. Re: PSQL bug?

   Dominique Devienne <ddevienne@gmail.com> — 2022-03-17T11:09:06Z

   On Thu, Mar 17, 2022 at 11:38 AM Pavel Stehule <pavel.stehule@gmail.com> wrote:
   >> Made a typo, [...], and got disconnected. Normal? --DD
   > I don't see any problem on master
   
   OK, good. Must have been fixed already then. Or was a fluke. Thanks
   for checking. --DD
   
   
   
   

4. Re: PSQL bug?

   Josef Šimánek <josef.simanek@gmail.com> — 2022-03-17T11:32:16Z

   čt 17. 3. 2022 v 12:06 odesílatel Dominique Devienne
   <ddevienne@gmail.com> napsal:
   >
   > On Thu, Mar 17, 2022 at 11:38 AM Pavel Stehule <pavel.stehule@gmail.com> wrote:
   > >> Made a typo, [...], and got disconnected. Normal? --DD
   > > I don't see any problem on master
   >
   > OK, good. Must have been fixed already then. Or was a fluke. Thanks
   > for checking. --DD
   
   I tried to reproduce with 14.2 client and latest 14, 13, 12 and 11
   servers without luck.
   
   >
   
   
   
   

5. Re: PSQL bug?

   Kyotaro Horiguchi <horikyota.ntt@gmail.com> — 2022-03-18T00:52:46Z

   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