Re: [HACKERS] alter table bug??? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] alter table bug???
Date
Msg-id 199812111622.LAA12403@candle.pha.pa.us
Whole thread Raw
In response to alter table bug???  (Terry Mackintosh <terry@terrym.com>)
List 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,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] 6.4.1 release
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] 6.4.1 release