Search Postgresql Archives

Re: REINDEX VERBOSE unknown option

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



My patch was partially merged at https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=52dcfda48778d16683c64ca4372299a099a15b96.

Thanks to everyone involved in this discussion.

pá 13. 12. 2019 v 2:11 odesílatel Josef Šimánek <josef.simanek@xxxxxxxxx> napsal:
I was thinking about this problem and possible documentation change again and I have prepared documentation change to solve this. See attached screenshot and HTML.

Code change can be found at https://github.com/simi/postgres/pull/3 (diff - https://github.com/simi/postgres/pull/3.diff, patch - https://github.com/simi/postgres/pull/3.patch).

This change is based on idea of Pave Stěhule, thanks a lot for that! Similar approach was used recently in https://www.postgresql.org/docs/devel/sql-dropdatabase.html.

so 16. 11. 2019 v 18:43 odesílatel Josef Šimánek <josef.simanek@xxxxxxxxx> napsal:
Ahh, I just tried to do the same with reindexdb cli tool and the actual syntax is REINDEX (VERBOSE) TABLE sales; Sorry for unnecessary question. Anyway maybe we can add this to documentation as a example. I can prepare patch for this if welcomed.

so 16. 11. 2019 v 18:40 odesílatel Josef Šimánek <josef.simanek@xxxxxxxxx> napsal:
Hello,

according to https://www.postgresql.org/docs/11/sql-reindex.html VERBOSE option is valid for REINDEX command for 11.3 PostgreSQL server. Anyway I'm getting error using VERBOSE option.

project_production=# REINDEX VERBOSE TABLE sales;
ERROR:  syntax error at or near "VERBOSE"                
LINE 1: REINDEX VERBOSE TABLE sales;                                                      
Time: 0.235 ms

I'm wondering if I'm doing anything wrong or actual documentation is wrong. Any ideas?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux