From: | Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [SQL] Q: documentation bug ? |
Date: | 2016-02-04 17:56:54 |
Message-ID: | 56B390E6.3000007@timbira.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2016-02-04 18:01:59 | Re: Asp.net 5 and EF6 |
Previous Message | FarjadFarid(ChkNet) | 2016-02-04 17:52:59 | Re: Asp.net 5 and EF6 |
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-02-04 18:04:33 | Re: Create db fails using utility tool |
Previous Message | Shashank Dutt Jha | 2016-02-04 17:45:42 | Re: Create db fails using utility tool |