From: Tom Lane <tgl@sss.pgh.pa.us>
To: yongtaoh2022@gmail.com
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18290: \di+ can not show the same name indexes
In-reply-to: <18290-d645a814cc36cc06@postgresql.org>
References: <18290-d645a814cc36cc06@postgresql.org>
Comments: In-reply-to PG Bug reporting form <noreply@postgresql.org>
	message dated "Sun, 14 Jan 2024 06:57:15 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1240719.1705247863.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Sun, 14 Jan 2024 10:57:43 -0500
Message-ID: <1240720.1705247863@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1240720.1705247863%40sss.pgh.pa.us>
Precedence: bulk

PG Bug reporting form <noreply@postgresql.org> writes:
> gpadmin=3D# \di+
>                                           List of relations
>   Schema   | Name | Type  |  Owner  | Table | Persistence | Access metho=
d | =

>   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