pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Lamar Owen <lamar.owen@wgcr.org>
To: Don Baccus <dhogaza@pacifier.com>
Cc: Postgres Hackers List <hackers@postgreSQL.org>
Subject: Re: [HACKERS] Unable to create tables...
Date: Fri, 06 Aug 1999 14:14:08 -0400
Message-ID: <37AB25F0.CB67F617@wgcr.org> (raw)
References: <37AAFF29.958CE9F2@alumni.caltech.edu>
	<3.0.1.32.19990806094228.00e0388c@mail.pacifier.com>

Don Baccus wrote:
 
> I can't "drop table foo", getting an error message telling
> me the class doesn't exist, so that's not the problem.
 
> It would seem as some system table is being corrupted???

Check pg_tables and pg_class -- select * from pg_tables; will give you a
list of tables from the system catalog, and select * from ps_class; will
do the same for classes -- if the psuedo-dropped table shows in either
of these tables, delete it, and see if that helps.  If this indeed is a
system table corruption..... eeewwww....

Lamar Owen
WGCR Internet Radio



view thread (8+ messages)  latest in thread

Message-ID: <37AB25F0.CB67F617@wgcr.org>
Permalink:  ../37AB25F0.CB67F617@wgcr.org/
Also on:    postgresql.org/message-id/37AB25F0.CB67F617@wgcr.org

 · 

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: pgsql-docs@postgresql.org
  Cc: lamar.owen@wgcr.org, dhogaza@pacifier.com, hackers@postgreSQL.org
  Subject: Re: [HACKERS] Unable to create tables...
  In-Reply-To: <37AB25F0.CB67F617@wgcr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox