X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 5356C475E9D
	for <pgsql-sql@postgresql.org>; Fri,  2 May 2003 12:03:37 -0400 (EDT)
Received: from wolff.to (wolff.to [66.93.249.74])
	by postgresql.org (Postfix) with SMTP id C6DC5475E9D
	for <pgsql-sql@postgresql.org>; Fri,  2 May 2003 12:03:26 -0400 (EDT)
Received: (qmail 24797 invoked by uid 500); 2 May 2003 16:04:30 -0000
Date: Fri, 2 May 2003 11:04:30 -0500
From: Bruno Wolff III <bruno@wolff.to>
To: Matt Mello <alien@spaceship.com>
Cc: jasiek@klaster.net, pgsql-sql@postgresql.org
Subject: Re: implied FROM
Message-ID: <20030502160430.GB24597@wolff.to>
Mail-Followup-To: Matt Mello <alien@spaceship.com>,
	jasiek@klaster.net, pgsql-sql@postgresql.org
References: <3EB21AE6.4020205@klaster.net>
	<59964.24.243.219.116.1051883093.squirrel@earth.spaceship.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <59964.24.243.219.116.1051883093.squirrel@earth.spaceship.com>
User-Agent: Mutt/1.5.4i
X-Spam-Status: No, hits=-34.8 required=5.0
	tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,REFERENCES,
	REPLY_WITH_QUOTES,USER_AGENT_MUTT autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/29
X-Sequence-Number: 13194

On Fri, May 02, 2003 at 08:44:53 -0500,
  Matt Mello <alien@spaceship.com> wrote:
> Tomasz Myrta said:
> > <cut>
> > Some people
> > said,  that it is very useful inside update queries. The conclusion was
> > this  behaviour should stay as it is.
> 
> I see.  I would have to disagree with those people.

The problem is that there is currently no way to do this on delete
statements without having the tables joined automagically.

There was some talk going on in another thread in the last couple of days
of adding a GUC setting to force an error instead of a warning in this
case.