From: Josh Berkus <josh@agliodbs.com>
To: Richard Huxton <dev@archonet.com>
To: Jamie Lawrence <postgres@jal.org>
To: pgsql-sql@postgresql.org
Subject: Re: Fwd: Bad Join moment - how is this happening?
Date: Wed, 30 Jul 2003 12:38:48 -0700
Message-ID: <200307301238.48616.josh@agliodbs.com> (raw)
In-Reply-To: <200307302036.22095.dev@archonet.com>
References: <20030730200732.GW1073@jal.clueinc.net>
<200307302036.22095.dev@archonet.com>
Richard,
> I think this is the "adding a table into the FROM" feature of PG. You're
> referring to documents.xxx in the select and d.id in the FROM. PG tries to
> help out by adding the table into the FROM for you - hence cartesian join.
Aha! You're right.
> I think you can turn this "feature" off in the config file in 7.3.x (haven't
> checked this though)
Nope, it's a 7.4 feature to turn it off in .conf. Look under the
"compatibility" section (the last section) in 7.4's postgresql.conf.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
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: josh@agliodbs.com, dev@archonet.com, postgres@jal.org
Subject: Re: Fwd: Bad Join moment - how is this happening?
In-Reply-To: <200307301238.48616.josh@agliodbs.com>
* 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