Re: SET SEQSCAN TO OFF - error - Mailing list pgsql-sql

From Jeff Hoffmann
Subject Re: SET SEQSCAN TO OFF - error
Date
Msg-id 3AE833CF.32B60F5A@propertykey.com
Whole thread Raw
In response to SET SEQSCAN TO OFF - error  (Hans-Jürgen Schönig <hs@cybertec.at>)
List pgsql-sql
Hans-Jürgen Schönig wrote:
> 
> I have the command below like it is described in the documentation
> (http://www.archonet.com/pgdocs/force-index.html) but it doens't work.
> 
> SET SEQSCAN TO OFF;
> ERROR:  'seqscan' is not a valid option name
> 
> Does anybody know why?
> 

because the documentation is wrong.  the variable name is
ENABLE_SEQSCAN, i.e.:

SET ENABLE_SEQSCAN TO OFF;

should work.

-- 

Jeff Hoffmann
PropertyKey.com


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SET SEQSCAN TO OFF - error
Next
From: Tom Lane
Date:
Subject: Re: Regexps -- too complex?