X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D509B329C63 for ; Tue, 14 Sep 2004 19:30:47 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79258-07 for ; Tue, 14 Sep 2004 18:30:37 +0000 (GMT) Received: from nyetwork.org (nyetwork.org [64.251.84.38]) by svr1.postgresql.org (Postfix) with ESMTP id AB184329D15 for ; Tue, 14 Sep 2004 19:30:37 +0100 (BST) Received: from [127.0.0.1] (glider.psdhost.net [64.251.84.4]) by nyetwork.org (Postfix) with ESMTP id 2D6B621E5F9 for ; Tue, 14 Sep 2004 11:30:19 -0700 (PDT) Message-ID: <414738CA.8070300@nyetwork.org> Date: Tue, 14 Sep 2004 11:30:34 -0700 From: Wim Kerkhoff User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: pg_class / missing tables References: In-Reply-To: X-Enigmail-Version: 0.84.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/125 X-Sequence-Number: 14828 Hi Lee, Thanks for the ideas... Lee Wu wrote: >I had similar problem before. I was able to select from >the_missig_table. > > pmacct=# SELECT * from missing_table; ERROR: relation "missing" does not exist pmacct=# select * from missing_table; ERROR: relation "missing_table" does not exist pmacct=# \d missing_table Did not find any relation named "missing_table". pmacct=# select count(*) from pg_class where relname='missing_table'; count ------- 0 (1 row) pmacct=# create table missing_table(foo int); ERROR: type "missing_table" already exists pmacct=# >What I did to fix my problem was to vacuum the whole database by login >psql: >vacuum; > > Didn't make any difference... :-( >Hope it helps! > > Nope :-( Thanks, Wim