| From: | "andrzej" <wppl16(at)wp(dot)pl> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #1408: don't see index |
| Date: | 2005-01-18 09:01:29 |
| Message-ID: | 200501180901.j0I91T69025279@developer.pgadmin.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1408
Logged by: andrzej
Email address: wppl16(at)wp(dot)pl
PostgreSQL version: 8.0.0-rc5
Operating system: windows XP
Description: don't see index
Details:
Create table t1
(
v varchar(5) not null,
m varchar(20),
d date,
l varchar(10),
primary key(v)
);
explain select * from t1 where v='abc'
result:
Seq Scan on t1 (....
Filter:((v)::text='abc'::text)
DON'T SEE INDEX PKEY ???????!!!!
but Postgres 7.4.2 Linux
explain select * from t1 where v='abc'
result:
Index Scan using t1_pkey on t1(...
Index Cond((v)::text='abc'::text)
SEE INDEX PKEY OK !!!!!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lutischn Ferenc | 2005-01-18 09:14:23 | BUG #1409: A good and a bad news: Crazy SQL JOIN? |
| Previous Message | Manikanti Sreedhar Reddy | 2005-01-18 06:03:07 | Re: BUG #1406: subsequent WHEN/ELSE is getting |