Skip site navigation (1) Skip section navigation (2)

BUG #1487: Index problem

From: "Tom Yeh" <tom_m_yeh(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1487: Index problem
Date: 2005-02-18 05:27:15
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      1487
Logged by:          Tom Yeh
Email address:      tom_m_yeh(at)yahoo(dot)com
PostgreSQL version: 8.0.1
Operating system:   Windows XP
Description:        Index problem

I created an index for a table, say Entity, on a field, say id.

Then, the follwoing two SQL has different result:

select * from "Entity" e where = '1000'


select * from  "Entity" e where like '1000'

(The later uses sequential scan. BTW, while 7.4.x uses index why 8.0 behave

Once I re-index it, the problem is gone. However, the problem comes back
randomly if I change some id.

The above can be replicated by using pgAdmin III only.


pgsql-bugs by date

Next:From: Jean-Pierre PelletierDate: 2005-02-18 15:48:28
Subject: could not read, could not write, could not fsync, Windows 2000, PostgreSQL 8.0.1
Previous:From: Andrew GoldDate: 2005-02-17 18:41:25
Subject: BUG #1486: Apostrophes are not ignored in pgplsql comments

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group