Re: DELETE ... USING

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DELETE ... USING
Дата
Msg-id 6459.1112671858@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: DELETE ... USING  (Neil Conway <neilc@samurai.com>)
Ответы Re: DELETE ... USING  (Neil Conway <neilc@samurai.com>)
Список 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 по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: DELETE ... USING
Следующее
От: Neil Conway
Дата:
Сообщение: Re: DELETE ... USING