Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199405300715.AAA06525@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Message-Id: <199405300715.AA28789@humus.cs.huji.ac.il>
To: postgres@postgres.Berkeley.EDU
Subject: postgres question
Date: Mon, 30 May 1994 10:15:25 +0300
From: Jorge Najenson <najenson@cs.huji.ac.il>
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 30 May 94 00:15:19 -0700
Resent-XMts: smtp


Sender: oris@CS.HUJI.AC.IL


Hi,

I wonder if you have an idea to solve my problem...


after creating database:
  createdb test1

and running the following shell script:

#!/bin/csh
monitor -c 'create Persons(id=int4,name=char16,address=char16,byear=int2)' $1
monitor -c 'create Books(serial=int4,title=char16,section=char16)' $1
monitor -c 'create Authors(id=int4,title=char16)' $1
monitor -c 'retrieve into tmp (p.name,year=p.byear)\
                from p in Persons,a in Authors,b in Books\
                where p.id=a.id and\
                        a.title=b.title and b.section="AI"' $1
monitor -c 'retrieve into tmp2 (year=int2max{tmp.year})' $1


I get the message :

   WARN:Dec 19 21:47:12:ExecAgg: no initial value given and no valid tuples 
found

which is logical since tmp is empty,but when I try to use the database again 
for let say :

   monitor -c 'retrieve (pg_class.all)' test1

I get :

   WARN:Dec 19 21:49:42:OperatorObjectIdFillScanKeyEntry: unknown operator 609

and it repeat it self for every query I try on that database.

even stranger, I cannot destroy the database with
   destroydb test1

because it hangs the postmaster which I have to kill and run again to 
successfully destroy the database.


I will be glad to get a quick reply since we give here a DataBase course and 
exercises will be given on the postgres system.

p.s. please add me to your mailing list.


Ori.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sternberg Ori,
C.S. System Group, Hebrew University,
Jerusalem 91904, ISRAEL.
oris@cs.huji.ac.il
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


------- End of Forwarded Message


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