On Tue, 28 Jun 2022 at 08:29, Simon Riggs <simon.ri...@enterprisedb.com> wrote: > > On Thu, 2 Jun 2022 at 01:02, Michael Paquier <mich...@paquier.xyz> wrote: > > > > On Tue, May 31, 2022 at 02:30:32PM +0200, Alvaro Herrera wrote: > > > I was thinking the opposite: REINDEX DATABASE with or without a database > > > name should always process the user relations and skip system catalogs. > > > If the user wants to do both, then they can use REINDEX SYSTEM in > > > addition. > > > > > > The reason for doing it like this is that there is no way to process > > > only user tables and skip catalogs. So this is better for > > > composability. > > > > No objections from me to keep this distinction at the end, as long as > > the the database name in the command has no impact on the chosen > > behavior. > > OK, that's clear. Will progress.
Attached patch is tested, documented and imho ready to be committed, so I will mark it so in CFapp. -- Simon Riggs http://www.EnterpriseDB.com/
reindex_not_require_database_name.v3.patch
Description: Binary data
