agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Biao Cheng <bcheng@cs.Buffalo.EDU>
To: postgres@postgres.Berkeley.EDU
Subject: A question about multi-retrieve in append
Date: Mon, 5 Dec 1994 23:07:51 -0500 (EST)
Message-ID: <199412060407.XAA22805@hydra.cs.Buffalo.EDU> (raw)

 
 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/

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: bcheng@cs.Buffalo.EDU
  Subject: Re: A question about multi-retrieve in append
  In-Reply-To: <199412060407.XAA22805@hydra.cs.Buffalo.EDU>

* 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