pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem 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