Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres ERROR

Postgres ERROR

From
"Esteban Chiner Sanz"
Date:
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

Re: [SQL] Postgres ERROR

From
Tom Lane
Date:
"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

Re: [SQL] Postgres ERROR

From
Bruce Momjian
Date:
> 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