From: Don Baccus <dhogaza@pacifier.com>
To: Lamar Owen <lamar.owen@wgcr.org>
Cc: Postgres Hackers List <hackers@postgreSQL.org>
Subject: Re: [HACKERS] Unable to create tables...
Date: Fri, 06 Aug 1999 11:23:47 -0700
Message-ID: <3.0.1.32.19990806112347.00e0d9b4@mail.pacifier.com> (raw)
In-Reply-To: <37AB25F0.CB67F617@wgcr.org>
References: <37AAFF29.958CE9F2@alumni.caltech.edu>
<3.0.1.32.19990806094228.00e0388c@mail.pacifier.com>
At 02:14 PM 8/6/99 -0400, Lamar Owen wrote:
>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....
Neither "pgdump_oid" or "foo" (my other example from my
follow-up message) appear to exist in pg_class or pg_tables.
Thanks for the suggestion, though :(
- Don Baccus, Portland OR <dhogaza@pacifier.com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
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: dhogaza@pacifier.com, lamar.owen@wgcr.org, hackers@postgreSQL.org
Subject: Re: [HACKERS] Unable to create tables...
In-Reply-To: <3.0.1.32.19990806112347.00e0d9b4@mail.pacifier.com>
* 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