Horton

Thread

  1. non-functional update notice unneccesarily

    Brett McCormickS <brett@abraxas.scene.com> — 1998-05-06T06:08:32Z

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

  2. Re: [HACKERS] non-functional update notice unneccesarily

    Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-05-06T14:06:01Z

    > 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

  3. Re: [HACKERS] non-functional update notice unneccesarily

    Bruce Momjian <maillist@candle.pha.pa.us> — 1998-06-16T02:51:13Z

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

  4. Re: [HACKERS] non-functional update notice unneccesarily

    Brett McCormick <brett@work.chicken.org> — 1998-06-16T20:58:40Z

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

  5. Re: [HACKERS] non-functional update notice unneccesarily

    Bruce Momjian <maillist@candle.pha.pa.us> — 1998-06-16T21:32:59Z

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