pgsql: reindexdb: Allow specifying objects to process in all databases.

From: Nathan Bossart <nathan(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: reindexdb: Allow specifying objects to process in all databases.
Date: 2024-03-11 20:43:12
Message-ID: E1rjmUK-003Izf-Di@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

reindexdb: Allow specifying objects to process in all databases.

Presently, reindexdb's --table, --schema, --index, and --system
options cannot be used together with --all, i.e., you cannot
specify objects to process in all databases. This commit removes
this unnecessary restriction. Furthermore, it removes the
restriction that --system cannot be used with --table, --schema,
and --index. There is no such restriction for the latter options,
and there is no technical reason to disallow these combinations.

Reviewed-by: Kyotaro Horiguchi, Dean Rasheed
Discussion: https://postgr.es/m/20230628232402.GA1954626%40nathanxps13

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/24c928ad9ad801048684569d2b67463c3ec8fdb0

Modified Files
--------------
doc/src/sgml/ref/reindexdb.sgml | 38 +++++------
src/bin/scripts/reindexdb.c | 114 ++++++++++++++++++---------------
src/bin/scripts/t/090_reindexdb.pl | 14 ++++
src/bin/scripts/t/091_reindexdb_all.pl | 20 ++++++
4 files changed, 110 insertions(+), 76 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2024-03-11 20:54:45 pgsql: Add tests for libpq query cancellation APIs
Previous Message Tom Lane 2024-03-11 20:21:52 Re: pgsql: Catalog changes preparing for builtin collation provider.