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