Postgres Pro
Downloads
Home   >   mailing lists

Thread: restriction clause selectivity bad value

restriction clause selectivity bad value

From
"Wallingford, Ted"
Date:
Can somebody translate this error to english for me :)

ERROR: RestrictionClauseSelectivity: bad value 2.451276

I'm getting it whenever I try to run an update query through ODBC.. any
ideas?

Thanks,

Ted Wallingford

Re: [ADMIN] restriction clause selectivity bad value

From
Marcio Macedo
Date:
I got an error like this after use alter table to add a column

when I do a select I got this:


database=> select * from table where column = 1;
ERROR:  RestrictionClauseSelectivity: bad value 2.452260

but if i do :
select * from table where column > 1;
it goes ok.

strange...


On Mon, 3 Jan 2000, Wallingford, Ted wrote:

> Can somebody translate this error to english for me :)
>
> ERROR: RestrictionClauseSelectivity: bad value 2.451276
>
> I'm getting it whenever I try to run an update query through ODBC.. any
> ideas?
>
> Thanks,
>
> Ted Wallingford
>
> ************
>

--
--Marcio Macedo
    Conectiva

"Se você assume que não há esperança,
 você garante que não haverá esperança.
 Se você assume que há um instinto de liberdade,
 há oportunidades para mudar as coisas."

-Noam Chomsky

Re: [ADMIN] restriction clause selectivity bad value

From
Bruce Momjian
Date:
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Can somebody translate this error to english for me :)
>
> ERROR: RestrictionClauseSelectivity: bad value 2.451276
>
> I'm getting it whenever I try to run an update query through ODBC.. any
> ideas?

My guess is you are running Alpha and you did an ALTER TABLE ADD
COLUMN, and not running 6.5.*.

In any event, run VACUUM ANALYZE on the table and it will be fixed.

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

Re: [ADMIN] restriction clause selectivity bad valueu

From
Bruce Momjian
Date:
[Charset ISO-8859-1 unsupported, filtering to ASCII...]
>
> I got an error like this after use alter table to add a column
>
> when I do a select I got this:
>
>
> database=> select * from table where column = 1;
> ERROR:  RestrictionClauseSelectivity: bad value 2.452260
>
> but if i do :
> select * from table where column > 1;
> it goes ok.

VACUUM ANALYZE the table.  6.5.* should not have this problem.

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