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 по дате отправления: