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

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

From: Decibel! <decibel(at)decibel(dot)org>
To: lucas(at)marx(dot)com(dot)br
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Table was deleted but it still been treated as not
Date: 2008-02-21 23:32:31
Message-ID: 1C10A4FE-D20C-4BD2-A612-E27414BB7B5D@decibel.org (view raw or flat)
Thread:
Lists: 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(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828


In response to

Responses

pgsql-admin by date

Next:From: dguevaraDate: 2008-02-21 23:49:40
Subject: Re: Trigger from a function
Previous:From: Decibel!Date: 2008-02-21 23:31:44
Subject: Re: Trigger from a function

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