Re: [ADMIN] restriction clause selectivity bad valueu - Mailing list pgsql-sql

[Charset ISO-8859-1 unsupported, filtering to ASCII...]
>
> I got an error like this after use alter table to add a column
>
> when I do a select I got this:
>
>
> database=> select * from table where column = 1;
> ERROR:  RestrictionClauseSelectivity: bad value 2.452260
>
> but if i do :
> select * from table where column > 1;
> it goes ok.

VACUUM ANALYZE the table.  6.5.* should not have this problem.

--
  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, Pennsylvania 19026