Re: [GENERAL] [SQL] Q: documentation bug ?

[Fabrízio de Royes Mello]

On 04-02-2016 08:53, 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
> 
>       root@hermes:~/bin# psql -d gnumed_v21 -U gm-dbo
>       Ausgabeformat ist „wrapped“.
>       Erweiterte Anzeige ist an.
>       psql (9.5.0)
>       Geben Sie „help“ für Hilfe ein.
> 
>       gnumed_v21=> select version();
>       -[ RECORD 1 
> ]-------------------------------------------------------------------------------------------
>       version | PostgreSQL 9.5.0 on i686-pc-linux-gnu, compiled by gcc 
> (Debian 5.3.1-5) 5.3.1 20160101, 32-bit
> 
>       gnumed_v21=> reindex<TAB>
>       DATABASE  INDEX     SCHEMA    SYSTEM    TABLE
> 
>       gnumed_v21=> reindex verbose database 'gnumed_v21';
>       ERROR:  syntax error at or near "verbose"
>       ZEILE 1: reindex verbose database 'gnumed_v21';
>                        ^
>       gnumed_v21=>
> 
> Does this constitute a bug in the documentation or in the Debian version of 
> PG ?
> 

You forgot to add the "(" and ")" around the "VERBOSE" statement
acoording the syntax.

Try this:

REINDEX (VERBOSE) DATABASE gnumed_v21;

Regards,

-- 
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

signature.asc
Description: OpenPGP digital signature