Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group