AW: REINDEX VERBOSE DATABASE not working

From: "William Sescu (Suva)" <william(dot)sescu(at)suva(dot)ch>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: AW: REINDEX VERBOSE DATABASE not working
Date: 2019-07-03 19:43:21
Message-ID: a007fd9297c349e4896166cd5d447e81@suva.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks for clarification. The REINDEX (VERBOSE) DATABASE xxx; works.
However, the syntax is not intuitive, from my point of view.
And TAB completion does not show you the (VERBOSE) option either.

e.g. if you press two times TAB, it does not show you the VERBOSE option

(postgres(at)[local]:55000)[knowledgebase]> REINDEX [TAB] [TAB]
DATABASE INDEX SCHEMA SYSTEM TABLE

Would it not be possible to allow 2 options. One with (VERBOSE) for backward compatibility and one with VERBOSE

Von: David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com]
Gesendet: Mittwoch, 3. Juli 2019 18:22
An: Avin Kavish <avinkavish(at)gmail(dot)com>
Cc: Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br>; Sescu William (SW0) <william(dot)sescu(at)suva(dot)ch>; pgsql-admin(at)postgresql(dot)org
Betreff: Re: REINDEX VERBOSE DATABASE not working

On Wed, Jul 3, 2019 at 8:56 AM Avin Kavish <avinkavish(at)gmail(dot)com<mailto:avinkavish(at)gmail(dot)com>> wrote:
That looks like a pretty bad syntax to require brackets around a keyword that has no contextual ambiguity.

Future pacing and overall consistency.

Here's a link to the relevant discussion:
https://www.postgresql.org/message-id/flat/CAD21AoA0pK3YcOZAFzMae%2B2fcc3oGp5zoRggDyMNg5zoaWDhdQ%40mail.gmail.com

David J.

________________________________

Disclaimer:

Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.

This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2019-07-03 20:32:48 REINDEX VERBOSE DATABASE not working
Previous Message Holger Jakobs 2019-07-03 16:49:40 Re: Fwd: Alternative to pg_lsclusters in RHEL/CentOS?