psql doesn't show tables duplicated in multiple schemas - Mailing list pgsql-bugs

From Wojciech Strzalka
Subject psql doesn't show tables duplicated in multiple schemas
Date
Msg-id CAJf-CGso9C6KJYSrj5N8eesyKR1iXiLm51aaiLHn19Ngpxsv6A@mail.gmail.com
Whole thread Raw
Responses Re: psql doesn't show tables duplicated in multiple schemas  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: psql doesn't show tables duplicated in multiple schemas  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-bugs

Setup 
----------------------
CREATE SCHEMA x;
CREATE SCHEMA y;
CREATE TABLE x.a(f int4);
CREATE TABLE x.b(f int4);
CREATE TABLE y.b(f int4);
CREATE TABLE y.c(f int4);
-----------------------

Test
-----------------------
docker=# set search_path=x;
SET
docker=# \d
       List of relations
 Schema | Name | Type  | Owner
--------+------+-------+--------
 x      | a    | table | docker
 x      | b    | table | docker
(2 rows)

docker=# set search_path=y;
SET
docker=# \d
       List of relations
 Schema | Name | Type  | Owner
--------+------+-------+--------
 y      | b    | table | docker
 y      | c    | table | docker
(2 rows)

docker=# set search_path=x,y;
SET
docker=# \d
       List of relations
 Schema | Name | Type  | Owner
--------+------+-------+--------
 x      | a    | table | docker
 x      | b    | table | docker
 y      | c    | table | docker
(3 rows)
-----------------------

I would expect last table listing to include 'y.b' table. Although shadowed when referencing by 'b' it's still there.

Tested with psql & postgres 13.3 



pgsql-bugs by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: BUG #17103: WAL segments are not removed after exceeding max_slot_wal_keep_size
Next
From: Pawel Kudzia
Date:
Subject: Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows