This is just to confirm that 8.2 beta3 fixes that problem.
Thanks again,
Jean-Pierre Pelletier
From: Tom Lane <[EMAIL PROTECTED]>
To: "JEAN-PIERRE PELLETIER" <[EMAIL PROTECTED]>
CC: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] ERROR: failed to build any 4-way joins SQL state:
XX000, PostgreSQL 8.2 beta1 Date: Tue, 24 Oct 2006 13:51:31 -0400
"JEAN-PIERRE PELLETIER" <[EMAIL PROTECTED]> writes:
> I have a query that throws "ERROR: failed to build any 4-way joins
Fixed --- thanks for the report! (This didn't make beta2, but will
be in the next one.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match