agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Vik Fearing <vik@2ndquadrant.fr>
To: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: [GENERAL] Q: documentation bug ?
Date: Thu, 4 Feb 2016 12:00:45 +0100
Message-ID: <56B32F5D.5090009@2ndquadrant.fr> (raw)
In-Reply-To: <20160204105318.GD22591@hermes.hilbert.loc>
References: <20160204105318.GD22591@hermes.hilbert.loc>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
On 02/04/2016 11:53 AM, Karsten Hilbert wrote:
> Hello all,
>
> the online documentation for REINDEX
>
> http://www.postgresql.org/docs/9.5/static/sql-reindex.html
>
> talks about VERBOSE
>
> Synopsis
>
> REINDEX [ ( { VERBOSE } [, ...] ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name
>
> [...]
>
> VERBOSE
>
> Prints a progress report as each index is reindexed.
>
> but
>
> gnumed_v21=> reindex verbose database 'gnumed_v21';
> ERROR: syntax error at or near "verbose"
> ZEILE 1: reindex verbose database 'gnumed_v21';
>
> Does this constitute a bug in the documentation or in the Debian version of PG ?
Neither. It's a little bit obscure because {} and [] mean special
things, but () doesn't. The syntax is therefore:
REINDEX (VERBOSE) DATABASE gnumed_v21;
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
view thread (6+ messages) latest in thread
Message-ID: <56B32F5D.5090009@2ndquadrant.fr>
Permalink: ../56B32F5D.5090009@2ndquadrant.fr/
Also on: postgresql.org/message-id/56B32F5D.5090009@2ndquadrant.fr
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: vik@2ndquadrant.fr, Karsten.Hilbert@gmx.net
Subject: Re: [GENERAL] Q: documentation bug ?
In-Reply-To: <56B32F5D.5090009@2ndquadrant.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox