VACUUM fails to parse 0 and 1 as boolean value - Mailing list pgsql-hackers

Hi,

VACUUM fails to parse 0 and 1 as boolean value

The document for VACUUM explains

    boolean
    Specifies whether the selected option should be turned on or off.
    You can write TRUE, ON, or 1 to enable the option, and FALSE, OFF,
    or 0 to disable it.

But VACUUM fails to parse 0 and 1 as boolean value as follows.

    =# VACUUM (INDEX_CLEANUP 1);
    ERROR:  syntax error at or near "1" at character 23
    STATEMENT:  VACUUM (INDEX_CLEANUP 1);

This looks a bug. The cause of this is a lack of NumericOnly clause
for vac_analyze_option_arg in gram.y. The attached patch
adds such NumericOnly. The bug exists only in 12dev.

Barring any objection, I will commit the patch.

Regards,

-- 
Fujii Masao