Re: [HACKERS] One I've never seen before: - Mailing list pgsql-hackers

quick appendum to my own...

the 'category' field was created with an 'alter table' command, if that
helps any...

even from psql, it comes back:

postgresql=> select category from tools where category = 'projects';
ERROR:  RestrictionClauseSelectivity: bad value 163645.593750

If I do it without the where clause, or a where cluase on any other field,
all appears well, its only teh one I created with 'alter table' that is
"screwed"...

Neat...if I rename the table to something else, the problem goes away.  If
I rename it to old_tools, it still exists, but if I rename it to software,
the problem disappears...*raised eyebrows*
and the table looks like:

postgresql=> \d tools

Table    = tools
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| userid                           | text                             |   var |
| title                            | text                             |   var |
| url                              | text                             |   var |
| platform                         | text                             |   var |
| app_version                      | text                             |   var |
| pg_version                       | text                             |   var |
| contact_name                     | text                             |   var |
| contact_email                    | text                             |   var |
| institution                      | text                             |   var |
| company_url                      | text                             |   var |
| keywords                         | text                             |   var |
| description                      | text                             |   var |
| rundate                          | datetime                         |     8 |
| category                         | text                             |   var |
+----------------------------------+----------------------------------+-------+

On Sun, 7 Feb 1999, The Hermit Hacker wrote:

> 
> ERROR:  RestrictionClauseSelectivity: bad value 163645.593750
> 
> The query is:
> 
> SELECT p.first_name, p.last_name, t.title, t.rundate, t.app_version,
> p.email 
>   FROM sw_password p, tools t 
>  WHERE p.userid = t.userid 
>    AND t.category = 'tools' 
>  ORDER by t.title;
> 
> Something wrong with that taht I'm not seeing? :(  
> 
> Marc G. Fournier                                
> Systems Administrator @ hub.org 
> primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 
> 
> 

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org