pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
SET SEQSCAN TO OFF - error
4+ messages / 4 participants
[nested] [flat]

* SET SEQSCAN TO OFF - error
@ 2001-04-23 21:02 Hans-Jürgen Schönig <hs@cybertec.at>
  2001-04-26 14:40 ` Re: SET SEQSCAN TO OFF - error Peter Eisentraut <peter_e@gmx.net>
  2001-04-26 14:42 ` Re: SET SEQSCAN TO OFF - error Jeff Hoffmann <jeff@propertykey.com>
  2001-04-26 14:46 ` Re: SET SEQSCAN TO OFF - error Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 3 replies; 4+ messages in thread

From: Hans-Jürgen Schönig @ 2001-04-23 21:02 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: SET SEQSCAN TO OFF - error
  2001-04-23 21:02 SET SEQSCAN TO OFF - error Hans-Jürgen Schönig <hs@cybertec.at>
@ 2001-04-26 14:40 ` Peter Eisentraut <peter_e@gmx.net>
  2 siblings, 0 replies; 4+ messages in thread

From: Peter Eisentraut @ 2001-04-26 14:40 UTC (permalink / raw)
  To: Hans-Jürgen Schönig <hs@cybertec.at>; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: SET SEQSCAN TO OFF - error
  2001-04-23 21:02 SET SEQSCAN TO OFF - error Hans-Jürgen Schönig <hs@cybertec.at>
@ 2001-04-26 14:42 ` Jeff Hoffmann <jeff@propertykey.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Jeff Hoffmann @ 2001-04-26 14:42 UTC (permalink / raw)
  To: Hans-Jürgen Schönig <hs@cybertec.at>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: SET SEQSCAN TO OFF - error
  2001-04-23 21:02 SET SEQSCAN TO OFF - error Hans-Jürgen Schönig <hs@cybertec.at>
@ 2001-04-26 14:46 ` Bruce Momjian <pgman@candle.pha.pa.us>
  2 siblings, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 2001-04-26 14:46 UTC (permalink / raw)
  To: Hans-Jürgen Schönig <hs@cybertec.at>; +Cc: pgsql-sql

> 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, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2001-04-26 14:46 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-23 21:02 SET SEQSCAN TO OFF - error Hans-Jürgen Schönig <hs@cybertec.at>
2001-04-26 14:40 ` Peter Eisentraut <peter_e@gmx.net>
2001-04-26 14:42 ` Jeff Hoffmann <jeff@propertykey.com>
2001-04-26 14:46 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox