From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | michel(at)michel(dot)enter(dot)it (ZioBudda) |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] strange error |
Date: | 1999-01-19 23:00:33 |
Message-ID: | 199901192300.SAA16804@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Chalmers | 1999-01-20 07:32:07 | Looking for a shopping cart/php3 combo |
Previous Message | ZioBudda | 1999-01-19 21:34:25 | strange error |