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 j

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

[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