Return-Path: owner-postman
Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with SMTP id UAA04905 for postgres-redist; Mon, 5 Dec 1994 20:08:15 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199412060408.UAA04905@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from hydra.cs.Buffalo.EDU (bcheng@hydra.cs.Buffalo.EDU [128.205.32.11]) by nobozo.CS.Berkeley.EDU (8.6.9/8.6.3) with ESMTP id UAA04895 for <postgres@postgres.berkeley.edu>; Mon, 5 Dec 1994 20:08:14 -0800
Received: (bcheng@localhost) by hydra.cs.Buffalo.EDU (8.6.8.1/8.6.4)
	id XAA22805 for postgres@postgres.berkeley.edu; Mon, 5 Dec 1994 23:07:51 -0500
From: Biao Cheng (Sam) <bcheng@cs.Buffalo.EDU>
Message-Id: <199412060407.XAA22805@hydra.cs.Buffalo.EDU>
Subject: A question about multi-retrieve in append
To: postgres@postgres.Berkeley.EDU
Date: Mon, 5 Dec 1994 23:07:51 -0500 (EST)
X-Mailer: ELM [version 2.4 PL23]
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 1156      
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 05 Dec 94 20:08:15 -0800
Resent-XMts: smtp

 
 Hi,
 
 I recently installed the latest/final version of postgres on
 our SUN systems running Solaris 2.3, I have no problem to run
 over all the tests.
 
 Now a class of students has been assigned a project using 
 postgres. One of the students did the following and got 
 the warning (Here, FACULTY and DEPARTMENT already defined 
 as classes beforehand):
 
 * create BELONGS ( Faculty = FACULTY, Department = DEPARTMENT ) \g
 Query sent to backend is "create BELONGS ( Faculty = FACULTY, Department = DEPARTMENT ) "
 CREATE
 
 * append BELONGS ( Faculty = "retrieve ( FACULTY.all ) 
 			where FACULTY.SSN = 123456789",
 	 Department = "retrieve ( DEPARTMENT.all ) 
 		where DEPARTMENT.DName = \\"Computer Science\\" ") \g
 Query sent to backend is "append BELONGS ( Faculty = "retrieve ( FACULTY.all )  			where FACULTY.Ssn = 123456789", 		 Department = "retrieve ( DEPARTMENT.all )  			where DEPARTMENT.DName = \"Computer Science\" ") "
 WARN:Dec  5 22:52:04:ProcedureDefine: procedure zyxset already exists with same arguments
 
 What is procedure zyxset? I have no clue about that.
 Any help is highly appreciated.
 
 Thanks,
 Biao Cheng
 
 
 
> 


==============================================================================
   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/