agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Jean T. Anderson <jta@desargues.UCSD.EDU>
To: Thilo Gaul <gaul@ira.uka.de>
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: Crashed database?
Date: Fri, 29 Apr 1994 10:25:08 -0700 (PDT)
Message-ID: <Pine.3.89.9404291031.A26817-0100000@desargues> (raw)
In-Reply-To: <"iraun1.ira.648:29.04.94.16.33.33"@ira.uka.de>

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

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: jta@desargues.UCSD.EDU, gaul@ira.uka.de
  Subject: Re: Crashed database?
  In-Reply-To: <Pine.3.89.9404291031.A26817-0100000@desargues>

* 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