Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA03484; Mon, 8 Jun 92 16:46:45 -0700
Date: Mon, 8 Jun 92 16:46:45 -0700
Message-Id: <9206082346.AA03484@postgres.Berkeley.EDU>
From: Deborah Swanberg <deborah@citi.umich.edu>
Subject: replace question in inherited attributes
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu


How do I replace the value of an inherited attribute, if
I don't know which relation contains the attribute?


For example, in the demo database, I run the command "retrieve (p.name)
from p in person*".  This returns a person named "cim".  Suppose this
person should really be named "jim", and I don't know which relation
contains "cim".

How do I change the name "cim" to "jim"?

After the example on page 6 of the paper "The POSTGRES Data Model", I
tried executing the following command, and received the following
error:


>* replace p(name="jim") from p in person* where p.name="cim"
>\g
> 
> Query sent to backend is "replace p(name="jim") from p in person* where
> p.name="cim" "
> WARN:Jun  8 19:29:47:heap_replace: (am)invalid otid
	
	 
Have I typed something wrong, or is this functionality a ghost feature?
If this is a ghost feature, how do people get around it?


Deborah Swanberg
University of Michigan