Re: [HACKERS] non-functional update notice unneccesarily

Поиск
Список
Период
Сортировка
От Thomas G. Lockhart
Тема Re: [HACKERS] non-functional update notice unneccesarily
Дата
Msg-id 35506E49.B75665B6@alumni.caltech.edu
обсуждение исходный текст
Ответ на non-functional update notice unneccesarily  (Brett McCormickS <brett@abraxas.scene.com>)
Список pgsql-hackers
> update mempayment set paywho = 'icvproxy' from do_addpayment where dappays
> eq = payseqid;
> NOTICE:  Non-functional update, only first update is performed
> UPDATE 31
>
> more than one update was indeed performed..

This is a confusing message, but I think it means that the
parser/planner/optimizer decided to simplify your over-specified or
redundant query. Don't know enough details about your tables and query
to know for sure in this case, but you can see examples of this in the
regression test suite.

                    - Tom

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Meskes
Дата:
Сообщение: initdb still doesn't work
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: AW: [HACKERS] Re: [QUESTIONS] groups of users