BUG #1408: don't see index

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: Raw Message | Whole Thread | 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 !!!!!

Responses

Browse pgsql-bugs by date

  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