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