Обсуждение: Postgres ERROR
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 Thank you, Esteban
"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
> 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 VACUUM ANALYZE your table. 6.4 has problems with ALTER TABLE ADD COLUMN and Alpha cpus. -- 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, Pennsylvania19026