Re: [GENERAL] Q: documentation bug ? - Mailing list pgsql-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