Re: [GENERAL] strange error

> I don't know if this mailing list is the appropriate ML, but:
> I think that in postgresql 6.3.2 there is a little bug.
> I have a table. I exec:
> alter table my_table add column mycolumn mytype\g
> now if I make a select on this new column I get this error
>
> ERROR:  RestrictionClauseSelectivity: bad value 2.350645
>
> Otherwise, if I drop the my_table and recreate my_table with the new
> column all
> is work. Why this ?

Somehow the analyze statistics has goteen out of wack.  Do a VACUUM
ANALYZE on the table, and the problem will go away.  If can reproduce
the problem, please send the information to the hackers list.  Thanks.

--
  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