Steve Atkins wrote:
On Apr 21, 2007, at 3:41 PM, Tom Lane wrote:
"Raymond O'Donnell" <rod@xxxxxx> writes:
I've just run into the above error (with the additional message "SQL
state XX000").
Funny thing is, when I change the join (between the views) either to an
INNER JOIN or a RIGHT JOIN, the query works - it only goes belly-up when
I try a LEFT JOIN.
This sounds like a known bug in 8.2.x --- it's fixed for 8.2.4. If
you can still reproduce it with 8.2.4, please provide the test case.
Any guesses on the timeframe for packaging 8.2.4?
ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/v8.2.4
Cheers,
Steve
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
