Postgres Pro
Downloads
Home   >   mailing lists

Table was deleted but it still been treated as not - Mailing list pgsql-admin

From Lucas Sanabio
Subject Table was deleted but it still been treated as not
Date
Msg-id 91d5bf2c0802211426n52941904n114b80bf4bab31aa@mail.gmail.com
Whole thread Raw
Responses Re: Table was deleted but it still been treated as not
List pgsql-admin
Tree view
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@marx.com.br
Tel: (62) 3281-9889 ou (62) 8117-5266

pgsql-admin by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: Power outage borked things (8.1.10)...
Next
From: Shilpa Sudhakar
Date:
Subject: Re: pg_ctl reload query