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

Table was deleted but it still been treated as not

From: "Lucas Sanabio" <lsanabio(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Table was deleted but it still been treated as not
Date: 2008-02-21 22:26:19
Message-ID: 91d5bf2c0802211426n52941904n114b80bf4bab31aa@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hello everyone.

I got a weird problem that I have no idea how to solve it. The problem is
that I have a table on my database which I can see it (pgAdmin III), but
when I click on it, it pop's an error telling me that the table does't
exist, but right after it it shows me all the table details on the other
panel. If I click to see the properties, I can see all the table properties,
but anything besides it always give me an "relation "vendas_orcamento_item"
doesn't exist".

I tried to vacumm all the data base, to refresh the view, drop the table,
but everything gives me that message.

Does anyone have any idea what could I do to solve this problem?

The postgres version is: 7.4_7.4.16

Thanks,

-- 
Lucas Sanabio
-----------------------------------------------------------------------------
Sun Certified Programmer for the Java 2 Platform
Consultor Java - Marx Tecnologia
URL: http://www.marx.com.br
Email: lucas(at)marx(dot)com(dot)br
Tel: (62) 3281-9889 ou (62) 8117-5266

Responses

pgsql-admin by date

Next:From: Shilpa SudhakarDate: 2008-02-21 23:11:50
Subject: Re: pg_ctl reload query
Previous:From: Hannes DorbathDate: 2008-02-21 22:00:08
Subject: Re: Power outage borked things (8.1.10)...

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