Re: DELETE ... USING - Mailing list pgsql-patches

From Tom Lane
Subject Re: DELETE ... USING
Date
Msg-id 6459.1112671858@sss.pgh.pa.us
Whole thread Raw
In response to Re: DELETE ... USING  (Neil Conway <neilc@samurai.com>)
Responses Re: DELETE ... USING
List pgsql-patches
Neil Conway <neilc@samurai.com> writes:
> Euler Taveira de Oliveira wrote:
>> euler=# delete from t1 where t1.a = t3.x;
>> DELETE 1
>> euler=#
>>
>> I think we need at least a NOTICE here. Of course it could be extended
>> to UPDATE too.

> I can see an argument for having a NOTICE here. On the other hand,
> add_missing_from will default to false in 8.1, ...

... but when it is TRUE, there should be a notice, same as there is in
SELECT.  UPDATE should produce such a notice too, IMHO.  Probably we
omitted the message originally because there was no way to avoid it
in a DELETE, but now there will be.

            regards, tom lane

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: Re: DELETE ... USING
Next
From: Neil Conway
Date:
Subject: Re: DELETE ... USING