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@gmail.com> 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 msI'm wondering if I'm doing anything wrong or actual documentation is wrong. Any ideas?
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 msI'm wondering if I'm doing anything wrong or actual documentation is wrong. Any ideas?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
