Skip site navigation (1) Skip section navigation (2)

Re: pg_class / missing tables

From: Wim Kerkhoff <wim(at)nyetwork(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_class / missing tables
Date: 2004-09-14 18:30:34
Message-ID: 414738CA.8070300@nyetwork.org (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

pgsql-admin by date

Next:From: Wim KerkhoffDate: 2004-09-14 18:33:46
Subject: Re: pg_class / missing tables
Previous:From: Lee WuDate: 2004-09-14 15:46:44
Subject: Re: pg_class / missing tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group