Hello David
Yes, I did read the thread. However, I still don’t see the advantage of running:
REINDEX ( VERBOSE ) DATABASE xxx;
Instead of:
REINDEX VERBOSE DATABASE xxx;
And coming back to the TAB completion thing, which is a fantastic feature, by the way, does not show you the option
which comes in parentheses. I don’t know if this is by design or not.
>REINDEX [TAB] [TAB]
DATABASE INDEX SCHEMA SYSTEM TABLE
I would expect with the current syntax implementation:
>REINDEX [TAB] [TAB]
(VERBOSE) DATABASE INDEX SCHEMA SYSTEM TABLE
Nevertheless, thanks everyone.
I think I will switch to the command line tool reindexdb. ;-) This one is more intuitive from my point of view:
reindexdb --verbose --dbname=xxx
Cheers,
William
Von: David G. Johnston [mailto:david.g.johnston@gmail.com]
Gesendet: Mittwoch, 3. Juli 2019 22:33
An: Sescu William (SW0) <william.sescu@suva.ch>
Cc: pgsql-admin@postgresql.org
Betreff: REINDEX VERBOSE DATABASE not working
On Wednesday, July 3, 2019, William Sescu (Suva) <william.sescu@suva.ch> wrote:
Thanks for clarification. The REINDEX (VERBOSE) DATABASE xxx; works.
However, the syntax is not intuitive, from my point of view.
Would it not be possible to allow 2 options. One with (VERBOSE) for backward compatibility and one with VERBOSE
Its possible but such a patch would never be committed (did you read the email thread?). Intuitiveness isn’t a huge concern here. Especially for a command that isn’t intended to be run manually often.
The learning curve for PostgreSQL includes knowing where to find command syntax and how to read it. Its a complex language that is constantly being added to.