Postgres Pro
Downloads
Home   >   mailing lists

Re: [PORTS] Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250 - Mailing list pgsql-ports

From Bruce Momjian
Subject Re: [PORTS] Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250
Date
Msg-id 199907091649.MAA01355@candle.pha.pa.us
Whole thread Raw
In response to Port Bug Report: ERROR:RestrictionClauseSelectivity: bad value 164739.656250  (Unprivileged user <nobody>)
List pgsql-ports
Tree view 
>
> jeff=> select * from psql_cds where mostrecent_sent=6.5;
> ERROR:  RestrictionClauseSelectivity: bad value 164739.656250
>

Vacuum analyze the table.  ALTER TABLE ADD COLUMN has messed things up.
Fixed in 6.5.


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

pgsql-ports by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [PORTS] Above 2G on a 32 bit architecture
Next
From: Bruce Momjian
Date:
Subject: Re: [PORTS] Port Bug Report: Command "CREATE TABLE AS with SELECT ... UNION" don't work