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
Attachment:
signature.asc
Description: OpenPGP digital signature
