Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch)

I also noticed that \d on an index doesn't warn about the invisible state
whereas \d on a table does:

[local]:5444 postgres(at)postgres=# SELECT indexrelid::regclass,
indisvalid, indisvisible FROM pg_index WHERE indexrelid =
'repli_pkey'::regclass \gx
-[ RECORD 1 ]+-----------
indexrelid | repli_pkey
indisvalid | f
indisvisible | f

[local]:5444 postgres(at)postgres=# \d repli_pkey
Index "public.repli_pkey"
Column | Type | Key? | Definition
--------+---------+------+------------
i | integer | yes | i
primary key, btree, for table "public.repli", invalid

[local]:5444 postgres(at)postgres=# \d repli
Table "public.repli"
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
i | integer | | not null |
t | text | | |
Indexes:
"repli_pkey" PRIMARY KEY, btree (i) INVISIBLE INVALID
Publications:
"pub"

The attached patch adds the flag.

[local]:5444 postgres(at)postgres=# \d repli_pkey
Index "public.repli_pkey"
Column | Type | Key? | Definition
--------+---------+------+------------
i | integer | yes | i
primary key, btree, for table "public.repli", invalid, invisible