Re: Proposal : REINDEX xxx VERBOSE

On 2/24/15 8:28 AM, Sawada Masahiko wrote:
>>According to the above discussion, VACUUM and REINDEX should have
>>trailing options. Tom seems (to me) suggesting that SQL-style
>>(bare word preceded by WITH) options and Jim suggesting '()'
>>style options? (Anyway VACUUM gets the*third additional* option
>>sytle, but it is the different discussion from this)

Well, almost everything does a trailing WITH. We need to either stick
with that for consistency, or add leading () as an option to those WITH
commands.

Does anyone know why those are WITH? Is it ANSI?

As a refresher, current commands are:

VACUUM (ANALYZE, VERBOSE) table1 (col1);
REINDEX INDEX index1 FORCE;
COPY table1 FROM 'file.txt' WITH (FORMAT csv);
CREATE MATERIALIZED VIEW mv1 WITH (storageparam, ...) AS qry WITH DATA;
CREATE EXTENSION ext1 WITH SCHEMA s1 VERSION v1 FROM over;
CREATE ROLE role WITH LOGIN;
GRANT .... WITH GRANT OPTION;
CREATE VIEW v1 AS qry WITH CASCADED CHECK OPTION;
ALTER DATABASE db1 WITH CONNECTION LIMIT 50;
DECLARE c1 INSENSITIVE SCROLL CURSOR WITH HOLD;
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com