pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problem with simple select, RestrictionClauseSelectivity ERROR
4+ messages / 4 participants
[nested] [flat]

* Problem with simple select, RestrictionClauseSelectivity ERROR
@ 1999-01-13 17:34 Patricia Rodriguez-Tome <tome@ebi.ac.uk>
  1999-01-13 18:51 ` Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: Patricia Rodriguez-Tome @ 1999-01-13 17:34 UTC (permalink / raw)
  To: pgsql-sql



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


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.
What have I done wrong? thanks for any pointers, here is all my table def (and 
data since there are only 3 rows !)


The table is very small :
rhalloc=> select * from groupe;
id|contact_id|  sub_date|size|release_date|status |species
--+----------+----------+----+------------+-------+-------
 1|        31|23-04-1998| 474|            |pending|mouse  
 2|        36|03-08-1998|3496|            |pending|mouse  
 3|         3|28-05-1998| 799|            |pending|mouse  
(3 rows)

and here is the format :
rhalloc=> \d groupe

Table    = groupe
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| id                               | int4 not null                    |     4 |
| contact_id                       | int4 not null                    |     4 |
| sub_date                         | date not null                    |     4 |
| size                             | int4 not null                    |     4 |
| release_date                     | date                             |     4 |
| status                           | text not null                    |   var |
| species                          | text                             |   var |
+----------------------------------+----------------------------------+-------+




cheers

pat

=======================================================================
Dr. Patricia Rodriguez-Tome		| URL:  http://www.ebi.ac.uk
R & D Coordinator
The EMBL Outstation, Hinxton - The European Bioinformatics Institute
Wellcome Trust genome Campus, Hinxton	| Tel:	+44 (0)1223 494 409
Cambridge CB10 1SD, UK			| Fax:	+44 (0)1223 494 468
========================================================================





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR
  1999-01-13 17:34 Problem with simple select, RestrictionClauseSelectivity ERROR Patricia Rodriguez-Tome <tome@ebi.ac.uk>
@ 1999-01-13 18:51 ` Bruce Momjian <maillist@candle.pha.pa.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Bruce Momjian @ 1999-01-13 18:51 UTC (permalink / raw)
  To: tome@ebi.ac.uk; +Cc: pgsql-sql

> 
> 
> 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR
@ 1999-01-13 19:24 Ari Jolma <ajolma@ahti.hut.fi>
  1999-01-14 09:25 ` Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR Dirk Lutzebaeck <lutzeb@aeccom.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Ari Jolma @ 1999-01-13 19:24 UTC (permalink / raw)
  To: Patricia Rodriguez-Tome <tome@ebi.ac.uk>; pgsql-sql

>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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR
  1999-01-13 19:24 Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR Ari Jolma <ajolma@ahti.hut.fi>
@ 1999-01-14 09:25 ` Dirk Lutzebaeck <lutzeb@aeccom.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Dirk Lutzebaeck @ 1999-01-14 09:25 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~1999-01-14 09:25 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-01-13 17:34 Problem with simple select, RestrictionClauseSelectivity ERROR Patricia Rodriguez-Tome <tome@ebi.ac.uk>
1999-01-13 18:51 ` Bruce Momjian <maillist@candle.pha.pa.us>
1999-01-13 19:24 Re: [SQL] Problem with simple select, RestrictionClauseSelectivity ERROR Ari Jolma <ajolma@ahti.hut.fi>
1999-01-14 09:25 ` Dirk Lutzebaeck <lutzeb@aeccom.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox