Re: failed to build any 5-way joins

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,
CONSTRAINT info_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_pkey PRIMARY 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 PRIMARY KEY (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;