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 e.id = '1000'
select * from "Entity" e where e.id 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 Pelletier||Date: 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 Gold||Date: 2005-02-17 18:41:25|
|Subject: BUG #1486: Apostrophes are not ignored in pgplsql comments|