Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR
Date
Msg-id 199901131851.NAA18284@candle.pha.pa.us
Whole thread Raw
In response to Problem with simple select, RestrictionClauseSelectivity ERROR  (Patricia Rodriguez-Tome <tome@ebi.ac.uk>)
List pgsql-sql
Tree view 
>
>
> 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@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

pgsql-sql by date:

Previous
From: JP Rosevear
Date:
Subject: Sequences and Views
Next
From: Ari Jolma
Date:
Subject: Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR