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

From Dirk Lutzebaeck
Subject Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR
Date
Msg-id 13981.47063.257958.945254@kamet.aeccom.com
Whole thread Raw
In response to Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR  (Ari Jolma <ajolma@ahti.hut.fi>)
List pgsql-sql
Ari Jolma writes:
 > >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
 > >
 > >I can select on all the other fields. The field species was added after the
 > >creation of the table, and the data in that field added at that time.
 >
 > I have had similar problems. I'm now used to fixing it by making a new table:


me too, i also had to copy the table but somehow lost all oids...

Dirk

pgsql-sql by date:

Previous
From: Dirk Lutzebaeck
Date:
Subject: Indexes on OIDs ?
Next
From: Dirk Lutzebaeck
Date:
Subject: Indexes on OIDs ?