Re: BUG #18290: \di+ can not show the same name indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #18290: \di+ can not show the same name indexes
Дата
Msg-id 1240720.1705247863@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #18290: \di+ can not show the same name indexes  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> gpadmin=# \di+
>                                           List of relations
>   Schema   | Name | Type  |  Owner  | Table | Persistence | Access method |
>   Size    | Description
> -----------+------+-------+---------+-------+-------------+---------------+------------+-------------
>  pg_temp_3 | idx1 | index | gpadmin | t2    | temporary   | btree         |
> 8192 bytes |
> (1 row)

> Both table `t1` and temp table `t2` have index idx, but `\di` only shows the
> index of table `t2`.

This is not a bug: \di is operating as documented, namely showing you
the indexes that are visible in your current search_path.  The
temp index masks the similarly-named one in public.  You could see
both of them with "\di+ *.*", "\di+ *.idx1", or other forms.  For
more info see

https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-PATTERNS

            regards, tom lane



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alexander Lakhin
Дата:
Сообщение: Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17798: Incorrect memory access occurs when using BEFORE ROW UPDATE trigger