From: Wim Kerkhoff <wim@nyetwork.org>
To: pgsql-admin@postgresql.org
Subject: Re: pg_class / missing tables
Date: Tue, 14 Sep 2004 11:30:34 -0700
Message-ID: <414738CA.8070300@nyetwork.org> (raw)
In-Reply-To: <ECAB83AA52BCC043A0E24BBC00001024111391@mxhq-exch.corp.mxlogic.com>
References: <ECAB83AA52BCC043A0E24BBC00001024111391@mxhq-exch.corp.mxlogic.com>
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
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: wim@nyetwork.org
Subject: Re: pg_class / missing tables
In-Reply-To: <414738CA.8070300@nyetwork.org>
References: <ECAB83AA52BCC043A0E24BBC00001024111391@mxhq-exch.corp.mxlogic.com> <414738CA.8070300@nyetwork.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