Re: [HACKERS] non-functional update notice unneccesarily - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] non-functional update notice unneccesarily
Date
Msg-id 199806162132.RAA05498@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] non-functional update notice unneccesarily  (Brett McCormick <brett@work.chicken.org>)
List pgsql-hackers
>
>
> 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)

pgsql-hackers by date:

Previous
From: dg@illustra.com (David Gould)
Date:
Subject: Re: [HACKERS] seq scan only when function not in subquery (bug?)
Next
From: t-ishii@sra.co.jp
Date:
Subject: using a btree index in order by clause?