Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199506282229.PAA01990@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Message-Id: <199506282226.SAA02484@kodokan.vivi.com>
To: postgres@postgres.Berkeley.EDU
Subject: Meaning of Update NOTICE?
Date: Wed, 28 Jun 1995 18:26:06 -0400
From: Bruce Cota <bruce@kodokan.vivi.com>
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Wed, 28 Jun 95 15:29:18 -0700
Resent-XMts: smtp


Hi, what is the meaning of this

NOTICE:Jun 28 18:14:42:Non-functional update, only first update is performed

It occurs in response to a simple UPDATE query of the form

UPDATE rel SET field1 = 'value1' WHERE field2 = 'value2';

This query updates a single tuple (no two tuples have the same value in
field2).

The cause seems to be that the tuple being UPDATEd was created by an
INSERT query  in the same transaction that contains the UPDATE.  When I
insert "end" and "begin" queries between the INSERT and UPDATE queries,
the NOTICE disappears.  

I could restructure to avoid this problem, but after a couple hours
isolating it, I'm beginning suspect that the NOTICE is inoccuous.


Thanks in advance for any information

	Bruce Cota


==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU".
   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================
              URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/