Horton

Re: [HACKERS] alter table bug???

Bruce Momjian <maillist@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: terry@terrym.com
Cc: hackers@postgreSQL.org
Date: 1998-12-11T16:22:46Z
Lists: pgsql-hackers 
> Indices:  listings_pkey
>           listings_url_key
> lse=> select * from listings where password = '093b7a6b';
> ERROR:  RestrictionClauseSelectivity: bad value 2.164003
> lse=> select password from listings where item_id = 1;
> password
> ----------
> 093b7a6b
> (1 row)
> 
> lse=>
> 
> Any ideas what that is all about?

VACUUM ANALYZE the table and see if that fixes it.

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