Message-ID: <000f01c3c3ea$1294efa0$0200a8c0@dedalus1>
From: "Alessandro Depase" <alessandro.depase@libero.it>
To: "Peter Eisentraut" <peter_e@gmx.net>, <pgsql-sql@postgresql.org>
References: <001e01c3c3ca$4c0c4af0$0200a8c0@dedalus1>
	<200312161430.47119.peter_e@gmx.net>
Subject: Re: failed to build any 5-way joins
Date: Tue, 16 Dec 2003 16:34:06 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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;