From: Peter Childs <peterachilds@gmail.com>
To: pgsql-sql@postgresql.org
Subject: delete from a using b in postgres 8.1.
Date: Mon, 2 Jan 2006 13:28:30 +0000
Message-ID: <a2de01dd0601020528j39555990i@mail.gmail.com> (raw)
a command such as
delete from a using b where a.one=b.one and b.two='foo';
works fine in 8.1 but fails totally in 8.0 however
delete from a where a.one=b.one and b.two='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.
This can break tones of clients admittedly the work around is quick but not
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 many
client developers are going to miss it before it goes back to the end user.
I also don't think this has been made particularly clear in changes.
Peter Childs
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: peterachilds@gmail.com
Subject: Re: delete from a using b in postgres 8.1.
In-Reply-To: <a2de01dd0601020528j39555990i@mail.gmail.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