agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Bruce Cota <bruce@kodokan.vivi.com>
To: postgres@postgres.Berkeley.EDU
Subject: Meaning of Update NOTICE?
Date: Wed, 28 Jun 1995 18:26:06 -0400
Message-ID: <199506282226.SAA02484@kodokan.vivi.com> (raw)


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/

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: bruce@kodokan.vivi.com
  Subject: Re: Meaning of Update NOTICE?
  In-Reply-To: <199506282226.SAA02484@kodokan.vivi.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox