Received: from ahti.hut.fi (IDENT:root@ahti.hut.fi [193.167.1.2]) by hub.org (8.9.1/8.9.1) with ESMTP id OAA18328 for ; Wed, 13 Jan 1999 14:24:36 -0500 (EST) (envelope-from ajolma@ahti.hut.fi) Received: from ariel.hut.fi (ariel.hut.fi [193.167.1.30]) by ahti.hut.fi (8.8.7/8.8.7) with SMTP id VAA12899; Wed, 13 Jan 1999 21:24:24 +0200 Message-Id: <3.0.32.19990113212421.006b78a0@ahti.hut.fi> X-Sender: ajolma@ahti.hut.fi X-Mailer: Windows Eudora Pro Version 3.0 (32) Date: Wed, 13 Jan 1999 21:24:24 +0200 To: Patricia Rodriguez-Tome , pgsql-sql@postgreSQL.org From: Ari Jolma Subject: Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >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: select * into new from old; this way the new column in the old table is not new anymore and the error goes away (I don't know what's happening under the hood) Ari