Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id LAA24723 for postgres-dist; Sun, 19 Dec 1993 11:58:01 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199312191958.LAA24723@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from cs.huji.ac.il (cs.huji.ac.il [132.65.16.10]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id LAA24714 for <postgres@nobozo.CS.Berkeley.EDU>; Sun, 19 Dec 1993 11:57:54 -0800
Received: from pita.cs.huji.ac.il by cs.huji.ac.il with SMTP id AA01721
  (5.65c/HUJI 4.153 for <postgres@nobozo.CS.Berkeley.EDU>); Sun, 19 Dec 1993 21:57:14 +0200
Received: from localhost by pita.cs.huji.ac.il with SMTP id AA08498
  (5.65c/HUJI 4.114 for <postgres@postgres.berkeley.edu>); Sun, 19 Dec 1993 21:57:12 +0200
Message-Id: <199312191957.AA08498@pita.cs.huji.ac.il>
To: postgres@postgres.Berkeley.EDU
Subject: a strange bug of database integrity
From: Sternberg Ori <oris@cs.huji.ac.il>
Cc: najenson@cs.huji.ac.il, oris@cs.huji.ac.il
Date: Sun, 19 Dec 93 21:57:08 +0200
X-Sender: oris@cs.huji.ac.il
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Sun, 19 Dec 93 11:58:01 -0800
Resent-XMts: smtp


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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~