From: | Vik Fearing <vik(at)2ndquadrant(dot)fr> |
---|---|
To: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: [GENERAL] Q: documentation bug ? |
Date: | 2016-02-04 11:00:45 |
Message-ID: | 56B32F5D.5090009@2ndquadrant.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general 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
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2016-02-04 11:05:32 | Re: [SQL] Q: documentation bug ? |
Previous Message | Karsten Hilbert | 2016-02-04 10:56:56 | Re: Q: documentation bug ? |
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2016-02-04 11:05:32 | Re: [SQL] Q: documentation bug ? |
Previous Message | Karsten Hilbert | 2016-02-04 10:56:56 | Re: Q: documentation bug ? |