pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (8+ messages)  latest in thread

Message-ID: <414738CA.8070300@nyetwork.org>
Permalink:  ../414738CA.8070300@nyetwork.org/
Also on:    postgresql.org/message-id/414738CA.8070300@nyetwork.org

 · 

reply

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