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

Tue, 5 May 1998 23:08:32 -0700
Brett McCormickS <brett@abraxas.scene.com>
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

Wed, 06 May 1998 14:06:01 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] 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..
> 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)

Mon, 15 Jun 1998 22:51:13 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] non-functional update notice unneccesarily

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

Tue, 16 Jun 1998 13:58:40 -0700 (PDT)
Brett McCormick <brett@work.chicken.org>
Re: [HACKERS] non-functional update notice unneccesarily
> 
> 
> 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)

Tue, 16 Jun 1998 17:32:59 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] non-functional update notice unneccesarily