agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Jorge Najenson <najenson@cs.huji.ac.il>
To: postgres@postgres.Berkeley.EDU
Subject: postgres question
Date: Mon, 30 May 1994 10:15:25 +0300
Message-ID: <199405300715.AA28789@humus.cs.huji.ac.il> (raw)


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

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: najenson@cs.huji.ac.il
  Subject: Re: postgres question
  In-Reply-To: <199405300715.AA28789@humus.cs.huji.ac.il>

* 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