Postgres Pro
Downloads
Home   >   mailing lists

Re: syntax error: VACUUM ANALYZE VERBOSE (PostgreSQL 11 regression) - Mailing list pgsql-hackers

From Sergei Kornilov
Subject Re: syntax error: VACUUM ANALYZE VERBOSE (PostgreSQL 11 regression)
Date
Msg-id 31052021540971291@iva5-750e13568e4d.qloud-c.yandex.net
Whole thread Raw
In response to syntax error: VACUUM ANALYZE VERBOSE (PostgreSQL 11 regression)  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: syntax error: VACUUM ANALYZE VERBOSE (PostgreSQL 11 regression)  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view 
Hi

At least this is documented behavior: 
> When the option list is surrounded by parentheses, the options can be written in any order. Without parentheses,
optionsmust be specified in exactly the order shown above.
 
https://www.postgresql.org/docs/current/static/sql-vacuum.html

Previously we have another additional synopsis
> VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table_name [ (column_name [, ...] ) ] ]
Seems this syntax was removed in this commit:
https://www.postgresql.org/message-id/E1dzW4X-00089L-5a%40gemulon.postgresql.org

regards, Sergei

pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: jsonpath
Next
From: Michael Paquier
Date:
Subject: Re: ToDo: show size of partitioned table