Re: [HACKERS] One I've never seen before:

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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>
>

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