pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedREINDEX VERBOSE DATABASE not working
6+ messages / 4 participants
[nested] [flat]
* REINDEX VERBOSE DATABASE not working
@ 2019-07-03 14:09 William Sescu (Suva) <william.sescu@suva.ch>
2019-07-03 14:13 ` RE: REINDEX VERBOSE DATABASE not working William Sescu (Suva) <william.sescu@suva.ch>
2019-07-03 14:14 ` Re: REINDEX VERBOSE DATABASE not working Fabrízio de Royes Mello <fabrizio@timbira.com.br>
0 siblings, 2 replies; 6+ messages in thread
From: William Sescu (Suva) @ 2019-07-03 14:09 UTC (permalink / raw)
To: pgsql-admin
Hello %
Regarding the Docs
https://www.postgresql.org/docs/11/sql-reindex.html
and due to the REINDEX syntax, I should be able to specify VERBOSE when I run the REINDEX command, to print a progress report.
(postgres@[local]:55000)[knowledgebase]> \h REINDEX
Command: REINDEX
Description: rebuild indexes
Syntax:
REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name
But it is not working.
(postgres@[local]:55000)[knowledgebase]> REINDEX VERBOSE DATABASE knowledgebase;
ERROR: syntax error at or near "VERBOSE"
LINE 1: REINDEX VERBOSE DATABASE knowledgebase;
^
Can somebody help me out regarding this issue.
Cheers
William
________________________________
Disclaimer:
Diese Nachricht und ihr eventuell angeh?ngte Dateien sind nur f?r den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich gesch?tzte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrt?mlich erreicht hat, bitten wir Sie h?flich, diese unter Ausschluss jeglicher Reproduktion zu l?schen und die absendende Person zu benachrichtigen. Danke f?r Ihre Hilfe.
This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.
Attachments:
smime.p7s (application/pkcs7-signature, 5.3K) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: REINDEX VERBOSE DATABASE not working
2019-07-03 14:09 REINDEX VERBOSE DATABASE not working William Sescu (Suva) <william.sescu@suva.ch>
@ 2019-07-03 14:13 ` William Sescu (Suva) <william.sescu@suva.ch>
1 sibling, 0 replies; 6+ messages in thread
From: William Sescu (Suva) @ 2019-07-03 14:13 UTC (permalink / raw)
To: pgsql-admin
I forgot to mention the version.
It is PostgreSQL 11.4 on Redhat 7.6
From: Sescu William (SW0)
Sent: Mittwoch, 3. Juli 2019 16:10
To: pgsql-admin@postgresql.org
Subject: REINDEX VERBOSE DATABASE not working [mail signed OK]
Hello %
Regarding the Docs
https://www.postgresql.org/docs/11/sql-reindex.html
and due to the REINDEX syntax, I should be able to specify VERBOSE when I run the REINDEX command, to print a progress report.
(postgres@[local]:55000)[knowledgebase]> \h REINDEX
Command: REINDEX
Description: rebuild indexes
Syntax:
REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name
But it is not working.
(postgres@[local]:55000)[knowledgebase]> REINDEX VERBOSE DATABASE knowledgebase;
ERROR: syntax error at or near "VERBOSE"
LINE 1: REINDEX VERBOSE DATABASE knowledgebase;
^
Can somebody help me out regarding this issue.
Cheers
William
________________________________
Disclaimer:
Diese Nachricht und ihr eventuell angehängte Dateien sind nur für den Adressaten bestimmt. Sie kann vertrauliche oder gesetzlich geschützte Daten oder Informationen beinhalten. Falls Sie diese Nachricht irrtümlich erreicht hat, bitten wir Sie höflich, diese unter Ausschluss jeglicher Reproduktion zu löschen und die absendende Person zu benachrichtigen. Danke für Ihre Hilfe.
This message and any attached files are for the sole use of the recipient named above. It may contain confidential or legally protected data or information. If you have received this message in error, please delete it without making any copies whatsoever and notify the sender. Thank you for your assistance.
Attachments:
smime.p7s (application/pkcs7-signature, 5.3K) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: REINDEX VERBOSE DATABASE not working
2019-07-03 14:09 REINDEX VERBOSE DATABASE not working William Sescu (Suva) <william.sescu@suva.ch>
@ 2019-07-03 14:14 ` Fabrízio de Royes Mello <fabrizio@timbira.com.br>
2019-07-03 15:56 ` Re: REINDEX VERBOSE DATABASE not working Avin Kavish <avinkavish@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Fabrízio de Royes Mello @ 2019-07-03 14:14 UTC (permalink / raw)
To: William Sescu (Suva) <william.sescu@suva.ch>; +Cc: pgsql-admin
Em qua, 3 de jul de 2019 às 11:09, William Sescu (Suva) <
william.sescu@suva.ch> escreveu:
> Hello %
>
>
>
> Regarding the Docs
>
>
>
> https://www.postgresql.org/docs/11/sql-reindex.html
>
>
>
> and due to the REINDEX syntax, I should be able to specify VERBOSE when I
> run the REINDEX command, to print a progress report.
>
>
>
> (postgres@[local]:55000)[knowledgebase]> \h REINDEX
>
> Command: REINDEX
>
> Description: rebuild indexes
>
> Syntax:
>
> REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } name
>
>
>
> But it is not working.
>
>
>
> (postgres@[local]:55000)[knowledgebase]> REINDEX VERBOSE DATABASE
> knowledgebase;
>
> ERROR: syntax error at or near "VERBOSE"
>
> LINE 1: REINDEX VERBOSE DATABASE knowledgebase;
>
> ^
>
>
>
> Can somebody help me out regarding this issue.
>
>
>
Your syntax is wrong. Try:
REINDEX (VERBOSE) DATABASE knowledgebase;
Regards
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: REINDEX VERBOSE DATABASE not working
2019-07-03 14:09 REINDEX VERBOSE DATABASE not working William Sescu (Suva) <william.sescu@suva.ch>
2019-07-03 14:14 ` Re: REINDEX VERBOSE DATABASE not working Fabrízio de Royes Mello <fabrizio@timbira.com.br>
@ 2019-07-03 15:56 ` Avin Kavish <avinkavish@gmail.com>
2019-07-03 16:21 ` Re: REINDEX VERBOSE DATABASE not working David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Avin Kavish @ 2019-07-03 15:56 UTC (permalink / raw)
To: Fabrízio de Royes Mello <fabrizio@timbira.com.br>; +Cc: William Sescu (Suva) <william.sescu@suva.ch>; pgsql-admin
That looks like a pretty bad syntax to require brackets around a keyword
that has no contextual ambiguity.
On Wed, Jul 3, 2019 at 7:44 PM Fabrízio de Royes Mello <
fabrizio@timbira.com.br> wrote:
> Em qua, 3 de jul de 2019 às 11:09, William Sescu (Suva) <
> william.sescu@suva.ch> escreveu:
>
>> Hello %
>>
>>
>>
>> Regarding the Docs
>>
>>
>>
>> https://www.postgresql.org/docs/11/sql-reindex.html
>>
>>
>>
>> and due to the REINDEX syntax, I should be able to specify VERBOSE when I
>> run the REINDEX command, to print a progress report.
>>
>>
>>
>> (postgres@[local]:55000)[knowledgebase]> \h REINDEX
>>
>> Command: REINDEX
>>
>> Description: rebuild indexes
>>
>> Syntax:
>>
>> REINDEX [ ( VERBOSE ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM }
>> name
>>
>>
>>
>> But it is not working.
>>
>>
>>
>> (postgres@[local]:55000)[knowledgebase]> REINDEX VERBOSE DATABASE
>> knowledgebase;
>>
>> ERROR: syntax error at or near "VERBOSE"
>>
>> LINE 1: REINDEX VERBOSE DATABASE knowledgebase;
>>
>> ^
>>
>>
>>
>> Can somebody help me out regarding this issue.
>>
>>
>>
>
> Your syntax is wrong. Try:
>
> REINDEX (VERBOSE) DATABASE knowledgebase;
>
> Regards
>
> --
> Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
> PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: REINDEX VERBOSE DATABASE not working
2019-07-03 14:09 REINDEX VERBOSE DATABASE not working William Sescu (Suva) <william.sescu@suva.ch>
2019-07-03 14:14 ` Re: REINDEX VERBOSE DATABASE not working Fabrízio de Royes Mello <fabrizio@timbira.com.br>
2019-07-03 15:56 ` Re: REINDEX VERBOSE DATABASE not working Avin Kavish <avinkavish@gmail.com>
@ 2019-07-03 16:21 ` David G. Johnston <david.g.johnston@gmail.com>
2019-07-03 20:32 ` REINDEX VERBOSE DATABASE not working David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: David G. Johnston @ 2019-07-03 16:21 UTC (permalink / raw)
To: Avin Kavish <avinkavish@gmail.com>; +Cc: Fabrízio de Royes Mello <fabrizio@timbira.com.br>; William Sescu (Suva) <william.sescu@suva.ch>; pgsql-admin
On Wed, Jul 3, 2019 at 8:56 AM Avin Kavish <avinkavish@gmail.com> wrote:
> That looks like a pretty bad syntax to require brackets around a keyword
> that has no contextual ambiguity.
>
Future pacing and overall consistency.
Here's a link to the relevant discussion:
https://www.postgresql.org/message-id/flat/CAD21AoA0pK3YcOZAFzMae%2B2fcc3oGp5zoRggDyMNg5zoaWDhdQ%40m...
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
* REINDEX VERBOSE DATABASE not working
2019-07-03 14:09 REINDEX VERBOSE DATABASE not working William Sescu (Suva) <william.sescu@suva.ch>
2019-07-03 14:14 ` Re: REINDEX VERBOSE DATABASE not working Fabrízio de Royes Mello <fabrizio@timbira.com.br>
2019-07-03 15:56 ` Re: REINDEX VERBOSE DATABASE not working Avin Kavish <avinkavish@gmail.com>
2019-07-03 16:21 ` Re: REINDEX VERBOSE DATABASE not working David G. Johnston <david.g.johnston@gmail.com>
@ 2019-07-03 20:32 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: David G. Johnston @ 2019-07-03 20:32 UTC (permalink / raw)
To: William Sescu (Suva) <william.sescu@suva.ch>; +Cc: pgsql-admin
On Wednesday, July 3, 2019, William Sescu (Suva) <william.sescu@suva.ch>
wrote:
> Thanks for clarification. The REINDEX (VERBOSE) DATABASE xxx; works.
>
> However, the syntax is not intuitive, from my point of view.
>
> Would it not be possible to allow 2 options. One with (VERBOSE) for
> backward compatibility and one with VERBOSE
>
>
Its possible but such a patch would never be committed (did you read the
email thread?). Intuitiveness isn’t a huge concern here. Especially for a
command that isn’t intended to be run manually often.
The learning curve for PostgreSQL includes knowing where to find command
syntax and how to read it. Its a complex language that is constantly being
added to.
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2019-07-03 20:32 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-07-03 14:09 REINDEX VERBOSE DATABASE not working William Sescu (Suva) <william.sescu@suva.ch>
2019-07-03 14:13 ` William Sescu (Suva) <william.sescu@suva.ch>
2019-07-03 14:14 ` Fabrízio de Royes Mello <fabrizio@timbira.com.br>
2019-07-03 15:56 ` Avin Kavish <avinkavish@gmail.com>
2019-07-03 16:21 ` David G. Johnston <david.g.johnston@gmail.com>
2019-07-03 20:32 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox