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