Postgres Pro
Downloads
Home   >   mailing lists

Thread: SET SEQSCAN TO OFF - error

SET SEQSCAN TO OFF - error

From
Hans-Jürgen Schönig
Date:
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?
   Hans

Re: SET SEQSCAN TO OFF - error

From
Peter Eisentraut
Date:
Hans-Jürgen Schönig writes:

> 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 'seqscan' is not a valid option name.  Maybe you mean
enable_seqscan.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

Re: SET SEQSCAN TO OFF - error

From
Bruce Momjian
Date:
> 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?
> 

Try:
test=> set enable_seqscan to off;SET VARIABLE

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026

Re: SET SEQSCAN TO OFF - error

From
Jeff Hoffmann
Date:
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