Thread: delete from a using b in postgres 8.1.

a command such as<br /><br /> delete from a using b where a.one=b.one and b.two='foo';<br /><br /> works fine in 8.1
butfails totally in 8.0 however<br /><br /> delete from a where a.one=b.one and b.two='foo';<br /><br /> works fine in
8.0and bellow but fails in 8.1 unless you have the add_missing_from option set to true in 8.1 <br /> Even then it
producesa nasty warning.<br /><br /> This can break tones of clients admittedly the work around is quick but not
particularlyneat. What do the other sql database do and is this just another inconstancy in SQL?<br /><br /> I realise
thiswas done to fix a bug but its a nasty sitting there that many client developers are going to miss it before it goes
backto the end user. I also don't think  this has been made particularly clear in changes.<br /><br /> Peter Childs<br
/>

On 1/2/06, Peter Childs <peterachilds@gmail.com> wrote:
> 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.
>

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 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
>

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)