Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA19627; Tue, 14 Jan 92 16:02:42 -0800
Date: Tue, 14 Jan 92 16:02:42 -0800
Message-Id: <9201150002.AA19627@postgres.Berkeley.EDU>
From: joseash@bush.tamu.edu (Alfredo Sanchez)
Subject: delete and replace behavior
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu


hello,

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.

Go 
* replace e(name="x") from e in OBJECTS where e.oid = "9999" \g

Query sent to backend is "replace e(name="x") from e in OBJECTS where e.oid = "9999" "
REPLACE
Go 
* replace e(name="x") from e in OBJECTS where e.oid ="x" \g

Query sent to backend is "replace e(name="x") from e in OBJECTS where e.oid ="x" "
REPLACE
Go 
* 

should i do a retrieve before any of these opns to 
make sure the tuples exist?

thanx a lot,

J Alfredo Sanchez H
-------------------
Hypertext Research Lab
Department of Computer Science
Texas A&M University