Re: [HACKERS] Unable to create tables...

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
Serviceand other goodies at http://donb.photo.net.