Lane" <[EMAIL PROTECTED]>
To: "Alessandro Depase" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, December 17, 2003 4:32 PM
Subject: Re: [SQL] failed to build any 5-way joins
> "Alessandro Depase" <[EMAIL PROTECTED]> writes:
&
"Alessandro Depase" <[EMAIL PROTECTED]> writes:
> select *
> from info where parent_infoid is null=20
> and fieldtypeid in (select fieldtypeid from users_auth_groups uag1, field_a=
> uth fa where userid =3D 8 and fa.groupid =3D uag1.groupid)=20
> and main_infoid in (select ic.infoid from info_cate
;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 16, 2003 5:12 PM
Subject: Re: [SQL] failed to build any 5-way joins
> On Tuesday 16 December 2003 15:34, Alessandro Depase wrote:
> >
> People smarter than me are looking at this, but I can give
On Tuesday 16 December 2003 15:34, Alessandro Depase wrote:
>
People smarter than me are looking at this, but I can give you some quick
feedback.
> Version? In my previous message I told that I'm using 7.4-1 on cygwin
> distribution. What other info do you need? How can I get them?
Are you sure i
Peter Eisentraut wrote:
> > The query generating the error is:
>
> This is useless unless we know table schema, what data is in the tables,
> and what software version you use.
I can just give you (at the end of this answer) the DDL for the fields I
reported in the query, but they are enough becau
"Alessandro Depase" <[EMAIL PROTECTED]> writes:
> I got the error message reported in the subject and I could not find anythi=
> ng about it anywhere.
It's a bug, but we can't do much about it unless you provide a
reproducible example. In addition to the query itself, schemas
for the tables invol
Alessandro Depase wrote:
> The query generating the error is:
This is useless unless we know table schema, what data is in the tables,
and what software version you use.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi all,
I got the error message reported in the subject and
I could not find anything about it anywhere.
I cannot get any explain plan for this
query.
I'm working on PosgreSQL 7.4-1, the latest cygwin
distribution I can find.
The query generating the error is:
select *from info where p
