Re: [BUGS] ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL

2006-11-08 Thread JEAN-PIERRE PELLETIER 

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

Re: [BUGS] ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL 8.2 beta1

2006-10-24 Thread Tom Lane 
"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

[BUGS] ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL 8.2 beta1

2006-10-24 Thread JEAN-PIERRE PELLETIER 

Hi,

I have a query that throws "ERROR: failed to build any 4-way joins
SQL state: XX000".

Here's an (arguably) simplified version of it that doesn't require any of my 
table:


select
  1
from
  (select 1 as col) t1

  cross join (select 1 as col) t2

  left outer join (select 1 as col) t3
  on  t1.col = t3.col
  and t2.col = t3.col
  and 1 = t3.col

  left outer join (select 1 as col) t4
  on t3.col = t4.col

I am on PostgreSQL 8.2 beta1 under Windows XP Service Pack 2.

Thanks,
Jean-Pierre Pelletier
e-djuster



---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster