[pg] DISCARD ALL does not remove the temporary tables

[VWagen1989]

postgres=# create temp table tt (id int);
CREATE TABLE
postgres=# select * from tt;
 id 
----
(0 rows)

postgres=# \d
                      List of relations
       Schema       |        Name         | Type  |  Owner   
--------------------+---------------------+-------+----------
 __sys__            | binlog_position     | table | postgres
 __sys__            | current_setting     | table | postgres
 performance_schema | global_status       | table | postgres
 __sys__            | persistent_variable | table | postgres
 __sys__            | pg_replication_lsn  | table | postgres
 __sys__            | pg_stat_replication | table | postgres
(6 rows)

postgres=# insert into tt values (1), (2);
INSERT 0 2
postgres=# select * from tt;
 id 
----
  1
  2
(2 rows)

postgres=# 
postgres=# discard all;
DISCARD ALL
postgres=# select * from tt;
 id 
----
  1
  2
(2 rows)

postgres=# ^D\q

% PGPASSWORD=postgres psql -h 127.0.0.1 -p 25432 -U postgres -d postgres
psql (17.0, server 15.0)
Type "help" for help.

postgres=# select * from tt;
 id 
----
  1
  2
(2 rows)

postgres=# \d
                      List of relations
       Schema       |        Name         | Type  |  Owner   
--------------------+---------------------+-------+----------
 __sys__            | binlog_position     | table | postgres
 __sys__            | current_setting     | table | postgres
 performance_schema | global_status       | table | postgres
 __sys__            | persistent_variable | table | postgres
 __sys__            | pg_replication_lsn  | table | postgres
 __sys__            | pg_stat_replication | table | postgres
(6 rows)