Re: failed to build any 5-way joins - Mailing list pgsql-sql

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 because I tried the example I'm
giving you (with all tables empty and without FK, while in the original
database they had less than 50 rows each) and I got the same result (so, it
should be data independent - but I understand that you meant that the error
could be data type dependent, so I give you the - reduced - tables
definitions).
I expected that the error was data independent, because, as I told before, I
could not get the plan for the not-working query.

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?
All I can think more than this is that I use a Windows XP O.S. and that I
got this error both using JDBC and using pgAdmin III (but it seems to me
that this is an error client-independent).

The other problem, however, as I asked before, is: where can I find the
documentation for this error (well, besides the source, of course)? are
there known limits in joining tables?

Thanks again
Bye
   Alessandro Depase

CREATE TABLE public.info
( infoid varchar(10) NOT NULL, parent_infoid varchar(10), main_infoid varchar(10), fieldtypeid varchar(10) NOT NULL,
CONSTRAINTinfo_pkey PRIMARY KEY (infoid)
 
) WITH OIDS;

CREATE TABLE public.users_auth_groups
( userid varchar(10) NOT NULL, groupid varchar(10) NOT NULL, CONSTRAINT users_auth_groups_pkey PRIMARY KEY (userid,
groupid)
) WITH OIDS;

CREATE TABLE public.field_auth
( groupid varchar(10) NOT NULL, fieldtypeid varchar(10) NOT NULL, read_write varchar(1) NOT NULL, CONSTRAINT
field_auth_pkeyPRIMARY KEY (groupid, fieldtypeid)
 
) WITH OIDS;

CREATE TABLE public.category_auth
( groupid varchar(10) NOT NULL, categoryid varchar(10) NOT NULL, read_write varchar(1), CONSTRAINT category_auth_pkey
PRIMARYKEY (groupid, categoryid)
 
) WITH OIDS;

CREATE TABLE public.info_category
( infoid varchar(10) NOT NULL, categoryid varchar(10) NOT NULL, CONSTRAINT info_category_pkey PRIMARY KEY (infoid,
categoryid)
) WITH OIDS;