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

Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: tome(at)ebi(dot)ac(dot)uk (Patricia Rodriguez-Tome)
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR
Date: 1999-01-13 18:51:54
Message-ID: 199901131851.NAA18284@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
> 
> 
> Hello,
> 
> I have a very simple select , and get an error back I do not understand
>  :
> rhalloc=> select id from groupe where species='mouse'; 
> ERROR:  RestrictionClauseSelectivity: bad value 
> -170141183460469231731687303715884105728.000000
> 

Do VACUUM ANALYZE on the table.  Somehow this value has gotten messed
up.


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-sql by date

Next:From: Ari JolmaDate: 1999-01-13 19:24:24
Subject: Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR
Previous:From: JP RosevearDate: 1999-01-13 18:28:01
Subject: Sequences and Views

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