On Aug 12, 2008, at 3:53 AM, Willy-Bas Loos wrote:
reproduced it on:
PostgreSQL 8.3.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC)
4.2.3 (Ubuntu 4.2.3-2ubuntu7)
3 rows with index, 2 rows without.
can not reproduce it on:
- PostgreSQL 8.1.10 on i486-pc-linux-gnu, compiled by GCC cc (GCC)
reproduced it on:
PostgreSQL 8.3.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.2.3
(Ubuntu 4.2.3-2ubuntu7)
3 rows with index, 2 rows without.
can not reproduce it on:
- PostgreSQL 8.1.10 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.1.3
20070831 (prerelease) (Ubuntu 4.1.2-16ubuntu1)
-
On Aug 12, 2008, at 3:53 AM, Willy-Bas Loos wrote:
reproduced it on:
PostgreSQL 8.3.3 on i486-pc-linux-gnu, compiled by GCC cc (GCC)
4.2.3 (Ubuntu 4.2.3-2ubuntu7)
3 rows with index, 2 rows without.
can not reproduce it on:
- PostgreSQL 8.1.10 on i486-pc-linux-gnu, compiled by GCC cc (GCC)
On Mon, Aug 11, 2008 at 10:35:26PM -0500, Matthew Dennis wrote:
In reference to the script below (I know it can be rewritten, that's
not the point), I get 3 rows if the referenced index exists but only
two rows if it does not. This is observable and repeatable just by
dropping/creating the
Matthew Dennis [EMAIL PROTECTED] writes:
In reference to the script below (I know it can be rewritten, that's not the
point), I get 3 rows if the referenced index exists but only two rows if it
does not.
I don't see any failure in 8.3 branch tip. I think the bug was fixed
here:
In reference to the script below (I know it can be rewritten, that's not the
point), I get 3 rows if the referenced index exists but only two rows if it
does not. This is observable and repeatable just by dropping/creating the
index. Drop the index and two rows are returned. Create the index,
