Re: [BUGS] Inconsistent query results after upgrading to Postgresql 8.4.0

2009-07-31 Thread Tom Lane
Ryan Wallace writes: > Query returns incorrect results when executed on PostgreSQL 8.4.0. The > same query was executed successfully on PostgreSQL 8.3.7. There have been some fixes in the semijoin-planning code since 8.4.0. Would you try your test case against a CVS pull or nightly snapshot?

[BUGS] Inconsistent query results after upgrading to Postgresql 8.4.0

2009-07-31 Thread Ryan Wallace
Your name: Nicholas Jakobsen, Ryan Wallace Your email address: nicholas.jakob...@telus.net, ryw...@gmail.com System Configuration: -   Architecture (example: Intel Pentium): Intel Core 2 Duo   Operating System (example: Linux 2.4.18): OS X 10.5 (Leopard)   PostgreSQL version