Received: from k2.aeccom.com (IDENT:root@gate1.aeccom.com [193.158.11.51]) by hub.org (8.9.1/8.9.1) with ESMTP id EAA11278 for ; Thu, 14 Jan 1999 04:25:27 -0500 (EST) (envelope-from lutzeb@aeccom.com) Received: from kamet.aeccom.com (lutzeb@kamet.aeccom.com [192.168.0.5]) by k2.aeccom.com (8.8.7/8.8.7) with ESMTP id KAA05383; Thu, 14 Jan 1999 10:26:01 +0100 Received: (from lutzeb@localhost) by kamet.aeccom.com (8.8.7/8.8.7) id KAA02262; Thu, 14 Jan 1999 10:25:33 +0100 From: Dirk Lutzebaeck MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Date: Thu, 14 Jan 1999 10:25:33 +0100 (CET) To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR In-Reply-To: <3.0.32.19990113212421.006b78a0@ahti.hut.fi> References: <3.0.32.19990113212421.006b78a0@ahti.hut.fi> X-Mailer: VM 6.43 under 20.4 "Emerald" XEmacs Lucid Message-ID: <13981.47063.257958.945254@kamet.aeccom.com> 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