Return-Path: owner-postman 
Delivery-Date: Fri, 29 Apr 94 13:15:24 -0700
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 KAA00939 for postgres-redist; Fri, 29 Apr 1994 10:27:25 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199404291727.KAA00939@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 ucsd.edu (ucsd.edu [132.239.254.201]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id KAA00927 for <postgres@nobozo.cs.berkeley.edu>; Fri, 29 Apr 1994 10:27:24 -0700
Received: from desargues.UCSD.EDU by ucsd.edu; id KAA29034
	sendmail 8.6.9/UCSD-2.2-sun via SMTP
	Fri, 29 Apr 1994 10:27:21 -0700
Received: by desargues.UCSD.EDU (5.0/SMI-SVR4)
	id AA26912 for postgres@nobozo.cs.berkeley.edu; Fri, 29 Apr 1994 10:25:09 +0800
Date: Fri, 29 Apr 1994 10:25:08 -0700 (PDT)
From: "Jean T. Anderson" <jta@desargues.UCSD.EDU>
Subject: Re: Crashed database?
To: Thilo Gaul <gaul@ira.uka.de>
Cc: postgres@postgres.Berkeley.EDU
In-Reply-To: <"iraun1.ira.648:29.04.94.16.33.33"@ira.uka.de>
Message-Id: <Pine.3.89.9404291031.A26817-0100000@desargues>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
content-length: 659
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Fri, 29 Apr 94 10:27:24 -0700
Resent-XMts: smtp

Does PKT exist in the database you are accessing? Names are case sensitive.
This query will list all classes that are not system catalogues:

     retrieve (p.relname)
     from     p in pg_class
     where    p.relkind="r" 
     and      p.relname !~ "pg_*"

 -jean

On Fri, 29 Apr 1994, Thilo Gaul wrote:
> I think I crashed my database, really don't know how:
> (these are my first steps in postgres)
> 
> Query sent to backend is "retrieve (PKT.all) where PKT.x=42 "
> WARN:Apr 29 18:15:37:heap_openr on PKT failed
> 
> other tables don't seem to be corrupted...
> do I have to rebuild the database or look for the backup ?
> every hint could be usefull;

===============================================================================
    To add/remove yourself 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.
===============================================================================