From: Alessandro Depase <alessandro.depase@libero.it>
To: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: failed to build any 5-way joins
Date: Tue, 16 Dec 2003 16:34:06 +0100
Message-ID: <000f01c3c3ea$1294efa0$0200a8c0@dedalus1> (raw)
References: <001e01c3c3ca$4c0c4af0$0200a8c0@dedalus1>
<200312161430.47119.peter_e@gmx.net>
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;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alessandro.depase@libero.it, peter_e@gmx.net
Subject: Re: failed to build any 5-way joins
In-Reply-To: <000f01c3c3ea$1294efa0$0200a8c0@dedalus1>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox