Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3QElT384472 for ; Thu, 26 Apr 2001 10:47:29 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.10.1/8.10.1) id f3QEkxd15245; Thu, 26 Apr 2001 10:46:59 -0400 (EDT) From: Bruce Momjian Message-Id: <200104261446.f3QEkxd15245@candle.pha.pa.us> Subject: Re: SET SEQSCAN TO OFF - error In-Reply-To: <3AE49880.6D5813D@cybertec.at> =?ISO-8859-1?Q?from_Hans-J=FCrgen_Sch=F6nig_at_Apr_23=2C_2001_11=3A02=3A56_p?= =?ISO-8859-1?Q?m?= To: =?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= Date: Thu, 26 Apr 2001 10:46:59 -0400 (EDT) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL90 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200104/404 X-Sequence-Number: 2764 > 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