From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
---|---|
To: | Lamar Owen <lamar(dot)owen(at)wgcr(dot)org> |
Cc: | Postgres Hackers List <hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] Unable to create tables... |
Date: | 1999-08-06 18:23:47 |
Message-ID: | 3.0.1.32.19990806112347.00e0d9b4@mail.pacifier.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
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(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
From | Date | Subject | |
---|---|---|---|
Next Message | Don Baccus | 1999-08-06 18:54:31 | Re: [HACKERS] Unable to create tables... |
Previous Message | Lamar Owen | 1999-08-06 18:14:08 | Re: [HACKERS] Unable to create tables... |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-08-06 18:25:22 | plpgsql requires bison |
Previous Message | Lamar Owen | 1999-08-06 18:14:08 | Re: [HACKERS] Unable to create tables... |