Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA21807; Tue, 14 Jan 92 18:30:09 -0800
Message-Id: <9201150230.AA21807@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: delete and replace behavior
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Tue, 14 Jan 92 16:02:42 PST."
             <9201150002.AA19627@postgres.Berkeley.EDU> 
Date: Tue, 14 Jan 92 18:29:14 PST

you write:

> when using delete and replace operations on tuples
> that have been deleted or never existed, both from
> the terminal monitor and C programs, i'm not
> getting the expected error return code. e.g.
> 
> should i do a retrieve before any of these opns to 
> make sure the tuples exist?

Because no tuples qualify in a replace or delete query isn't grounds
for returning an error status code.  If it's important to know one way
or the other then yes, do a retrieve or implement some other means
to determine this (postgres is a very versatile system).


Jeff Meredith
mer@postgres.berkeley.edu