[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
  [EMAIL PROTECTED]            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

************

Reply via email to