The documentation at
http://www.postgresql.org/docs/8.2/i...g-setting.html states
that:
Boolean values may be written as ON, OFF, TRUE, FALSE, YES, NO, 1, 0 (all
case-insensitive) or any unambiguous prefix of these.
But the following doesn't work:
postgres=# set enable_seqscan = of;
ERROR: parameter "enable_seqscan" requires a Boolean value
postgres=#
'of' is an unambiguous prefix of OFF, but it clearly doesn't work. Is it the
documentation that needs fix or is it the code?
I tried the following too:
set enable_seqscan = "of"; -- doesn't work
set enable_seqscan = "off"; -- works
BTW, I tried TR, TRU, FA, FAL, FALS, YE. They all work fine.
Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | yahoo }.com