non-functional update notice unneccesarily

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

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..
I beleive this has happened to me before..

Vadim has said to remove the message, and I have done so. The
surrounding code in heapam.c is unchanged, just the elog(NOTICE) is
commented out.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

There are times when the message is appropriate, I believe. But this
is not one of them. Are all instances of this message gone, or just
this one?

On Mon, 15 June 1998, at 22:51:13, Bruce Momjian wrote:

There are times when the message is appropriate, I believe. But this
is not one of them. Are all instances of this message gone, or just
this one?

On Mon, 15 June 1998, at 22:51:13, Bruce Momjian wrote:

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..
I beleive this has happened to me before..

Vadim has said to remove the message, and I have done so. The
surrounding code in heapam.c is unchanged, just the elog(NOTICE) is
commented out.

All instances are gone.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)