Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Postgres ERROR - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Postgres ERROR
Date
Msg-id 22411.931874515@sss.pgh.pa.us
Whole thread Raw
In response to Postgres ERROR  ("Esteban Chiner Sanz" <echiner@tissat.es>)
List pgsql-sql
Tree view 
"Esteban Chiner Sanz" <echiner@tissat.es> 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

pgsql-sql by date:

Previous
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [SQL] calculating percentages
Next
From: Tom Lane
Date:
Subject: Re: [SQL] "quoting" column names