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

From Decibel!
Subject Re: Table was deleted but it still been treated as not
Date
Msg-id 1C10A4FE-D20C-4BD2-A612-E27414BB7B5D@decibel.org
Whole thread Raw
In response to Table was deleted but it still been treated as not  ("Lucas Sanabio" <lsanabio@gmail.com>)
Responses Re: Table was deleted but it still been treated as not  ("Lucas Sanabio" <lsanabio@gmail.com>)
List pgsql-admin
On Feb 21, 2008, at 4:26 PM, Lucas Sanabio wrote:
> 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


What's it do in psql?
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



Attachment

pgsql-admin by date:

Previous
From: Decibel!
Date:
Subject: Re: Trigger from a function
Next
From: "dguevara"
Date:
Subject: Re: Trigger from a function