Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA92358 for ; Tue, 13 Jul 1999 10:02:32 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id KAA22413; Tue, 13 Jul 1999 10:01:55 -0400 (EDT) To: "Esteban Chiner Sanz" cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Postgres ERROR In-reply-to: Your message of Tue, 13 Jul 1999 13:30:37 +0200 <378B235C.5EDF5220@tissat.es> Date: Tue, 13 Jul 1999 10:01:55 -0400 Message-ID: <22411.931874515@sss.pgh.pa.us> From: Tom Lane "Esteban Chiner Sanz" writes: > What does this error mean? I've look for it in the documentation but I > haven't found it. > ERROR: RestrictionClauseSelectivity: bad value -1.998611 Sounds like some bad data has gotten into your pg_statistic table. You can probably fix the problem by running VACUUM ANALYZE. What Postgres version are you running? I recall hearing of someone seeing that error with a buggy pre-alpha version, but not with any production releases... regards, tom lane