| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Esteban Chiner Sanz" <echiner(at)tissat(dot)es> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] Postgres ERROR |
| Date: | 1999-07-13 14:01:55 |
| Message-ID: | 22411.931874515@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
"Esteban Chiner Sanz" <echiner(at)tissat(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-07-13 14:08:21 | Re: [SQL] "quoting" column names |
| Previous Message | Thomas Good | 1999-07-13 13:30:39 | Re: [SQL] calculating percentages |