Re: [ADMIN] restriction clause selectivity bad value

From: Marcio Macedo <marciom(at)conectiva(dot)com(dot)br>
To: "Wallingford, Ted" <twallingford(at)indexc(dot)com>
Cc: "'pgsql-sql(at)hub(dot)org'" <pgsql-sql(at)hub(dot)org>, "'pgsql-admin(at)hub(dot)org'" <pgsql-admin(at)hub(dot)org>
Subject: Re: [ADMIN] restriction clause selectivity bad value
Date: 2000-01-03 17:15:50
Message-ID: Pine.LNX.4.20.0001031513030.6043-100000@animaniacs.conectiva.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql


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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2000-01-03 17:19:43 Re: [ADMIN] restriction clause selectivity bad value
Previous Message Wallingford, Ted 2000-01-03 17:00:43 restriction clause selectivity bad value

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2000-01-03 17:19:43 Re: [ADMIN] restriction clause selectivity bad value
Previous Message Wallingford, Ted 2000-01-03 17:00:43 restriction clause selectivity bad value