Re: Table was deleted but it still been treated as not

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(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828