psql doesn't show tables duplicated in multiple schemas

Поиск
Список
Период
Сортировка
От Wojciech Strzalka
Тема psql doesn't show tables duplicated in multiple schemas
Дата
Msg-id CAJf-CGso9C6KJYSrj5N8eesyKR1iXiLm51aaiLHn19Ngpxsv6A@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: BUG #17103: WAL segments are not removed after exceeding max_slot_wal_keep_size
Следующее
От: Pawel Kudzia
Дата:
Сообщение: Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows