X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B2D969DC9F6 for ; Tue, 3 Jan 2006 15:18:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56141-06 for ; Tue, 3 Jan 2006 15:18:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200]) by postgresql.org (Postfix) with ESMTP id 6900B9DC9A3 for ; Tue, 3 Jan 2006 15:18:51 -0400 (AST) Received: by wproxy.gmail.com with SMTP id 57so2215581wri for ; Tue, 03 Jan 2006 11:18:52 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=BcAmwqF6sL024VvPvX5HJSOGJHxMxmzKbalECjuEhE9KfzBOiM0RWwpD7Q2gNtcV71MLR72/YQjr4pnTgNA0ArkX/8mdL9PKVZ3lB6s38uayraEdACS6vhwzPTyv96Lo0zHZUCL8zBdroL/6DlUfgwLQzOTRcua2jsxdqdq0jAA= Received: by 10.54.153.18 with SMTP id a18mr1362236wre; Tue, 03 Jan 2006 11:18:51 -0800 (PST) Received: by 10.54.92.14 with HTTP; Tue, 3 Jan 2006 11:18:51 -0800 (PST) Message-ID: Date: Tue, 3 Jan 2006 14:18:51 -0500 From: Jaime Casanova To: Peter Childs Subject: Re: delete from a using b in postgres 8.1. Cc: pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.078 required=5 tests=[AWL=0.078] X-Spam-Score: 0.078 X-Spam-Level: X-Archive-Number: 200601/9 X-Sequence-Number: 23798 On 1/2/06, Peter Childs wrote: > a command such as > > delete from a using b where a.one=3Db.one and b.two=3D'foo'; > > works fine in 8.1 but fails totally in 8.0 however > > delete from a where a.one=3Db.one and b.two=3D'foo'; > > works fine in 8.0 and bellow but fails in 8.1 unless you have the > add_missing_from option set to true in 8.1 > Even then it produces a nasty warning. > it will not break anything because you can set this flag in the VERSION/PLATFORM COMPATIBILITY section of postgresql.conf > This can break tones of clients admittedly the work around is quick but n= ot > particularly neat. What do the other sql database do and is this just > another inconstancy in SQL? > > I realise this was done to fix a bug but its a nasty sitting there that m= any > client developers are going to miss it before it goes back to the end use= r. > I also don't think this has been made particularly clear in changes. > > Peter Childs > -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)