Received: from candle.pha.pa.us (root@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA84024 for ; Tue, 30 Nov 1999 22:32:49 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id WAA00899; Tue, 30 Nov 1999 22:07:28 -0500 (EST) From: Bruce Momjian Message-Id: <199912010307.WAA00899@candle.pha.pa.us> Subject: Re: [SQL] RestrictionClauseSelectivity In-Reply-To: <3.0.6.32.19991130214502.0098deb0@execulink.com> from Frank Bax at "Nov 30, 1999 09:45:02 pm" To: Frank Bax Date: Tue, 30 Nov 1999 22:07:28 -0500 (EST) CC: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL65 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > DROP TABLE Players; > CREATE TABLE Players ( ReqWhen DATETIME ); > ALTER TABLE Players ADD ReqCode TEXT; > ALTER TABLE Players ADD ReqName TEXT; > ALTER TABLE Players ADD ReqMail TEXT; > ALTER TABLE Players ADD ReqPlay TEXT; > ALTER TABLE Players ADD ReqFeed TEXT; > ALTER TABLE Players ADD ReqPend CHAR; > SELECT * FROM Players WHERE ReqCode = 'Test'; > > Always produces the following error message: > > ERROR: RestrictionClauseSelectivity: bad value 2.451276 > > I'm on 6.4.2 I think. Whatever was on RedHat 6.0 CD. > How do I confirm version without the install files? Known bug. Upgrade to 6.5.3, or VACUUM ANALYZE the table. -- Bruce Momjian | http://www.op.net/~candle maillist@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