pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
restriction clause selectivity bad value
4+ messages / 3 participants
[nested] [flat]

* restriction clause selectivity bad value
@ 2000-01-03 17:00 Wallingford, Ted <twallingford@indexc.com>
  2000-01-03 17:15 ` Re: [ADMIN] restriction clause selectivity bad value Marcio Macedo <marciom@conectiva.com.br>
  2000-01-03 17:19 ` Re: [ADMIN] restriction clause selectivity bad value Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 2 replies; 4+ messages in thread

From: Wallingford, Ted @ 2000-01-03 17:00 UTC (permalink / raw)
  To: 'pgsql-sql@hub.org' <pgsql-sql@hub.org>; 'pgsql-admin@hub.org' <pgsql-admin@hub.org>

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [ADMIN] restriction clause selectivity bad value
  2000-01-03 17:00 restriction clause selectivity bad value Wallingford, Ted <twallingford@indexc.com>
@ 2000-01-03 17:15 ` Marcio Macedo <marciom@conectiva.com.br>
  2000-01-03 17:20   ` Re: [ADMIN] restriction clause selectivity bad valueu Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 1 reply; 4+ messages in thread

From: Marcio Macedo @ 2000-01-03 17:15 UTC (permalink / raw)
  To: Wallingford, Ted <twallingford@indexc.com>; +Cc: 'pgsql-sql@hub.org' <pgsql-sql@hub.org>; 'pgsql-admin@hub.org' <pgsql-admin@hub.org>


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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [ADMIN] restriction clause selectivity bad valueu
  2000-01-03 17:00 restriction clause selectivity bad value Wallingford, Ted <twallingford@indexc.com>
  2000-01-03 17:15 ` Re: [ADMIN] restriction clause selectivity bad value Marcio Macedo <marciom@conectiva.com.br>
@ 2000-01-03 17:20   ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 2000-01-03 17:20 UTC (permalink / raw)
  To: Marcio Macedo <marciom@conectiva.com.br>; +Cc: Wallingford, Ted <twallingford@indexc.com>; 'pgsql-sql@hub.org' <pgsql-sql@hub.org>; 'pgsql-admin@hub.org' <pgsql-admin@hub.org>

[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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [ADMIN] restriction clause selectivity bad value
  2000-01-03 17:00 restriction clause selectivity bad value Wallingford, Ted <twallingford@indexc.com>
@ 2000-01-03 17:19 ` Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 2000-01-03 17:19 UTC (permalink / raw)
  To: Wallingford, Ted <twallingford@indexc.com>; +Cc: 'pgsql-sql@hub.org' <pgsql-sql@hub.org>; 'pgsql-admin@hub.org' <pgsql-admin@hub.org>

[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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2000-01-03 17:20 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-03 17:00 restriction clause selectivity bad value Wallingford, Ted <twallingford@indexc.com>
2000-01-03 17:15 ` Marcio Macedo <marciom@conectiva.com.br>
2000-01-03 17:20   ` Re: [ADMIN] restriction clause selectivity bad valueu Bruce Momjian <pgman@candle.pha.pa.us>
2000-01-03 17:19 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox