Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id PAA01990 for postgres-redist; Wed, 28 Jun 1995 15:29:18 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199506282229.PAA01990@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from westnet.com (uucp@westnet.com [199.0.227.2]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id PAA01980 for <postgres@postgres.berkeley.edu>; Wed, 28 Jun 1995 15:29:16 -0700
Received: (from uucp@localhost) by westnet.com (8.6.12/8.6.12) with UUCP id SAA08507 for postgres@postgres.berkeley.edu; Wed, 28 Jun 1995 18:29:27 -0400
Received: from localhost (bruce@localhost) by kodokan.vivi.com (8.6.12/8.6.12) with SMTP id SAA02484 for <postgres@postgres.berkeley.edu>; Wed, 28 Jun 1995 18:26:06 -0400
Message-Id: <199506282226.SAA02484@kodokan.vivi.com>
X-Authentication-Warning: kodokan.vivi.com: Host localhost didn't use HELO protocol
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/