Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4EE352E005B for ; Thu, 21 Feb 2008 18:26:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 15638-02 for ; Thu, 21 Feb 2008 18:26:23 -0400 (AST) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.175]) by postgresql.org (Postfix) with ESMTP id 9DFAE2E0078 for ; Thu, 21 Feb 2008 18:26:27 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id j3so1116365ugf.49 for ; Thu, 21 Feb 2008 14:26:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:reply-to:to:subject:mime-version:content-type; bh=C7BykTIMi3ajy+85azBsmjzmDsfyvUcRmY2iBGrD9YA=; b=uUwgPN9Et+e/SJ9LvZ0N7JA9oFSe+2VedxpCCWZnPbeDWYOQrps/BS+ZceB+7U9qTuiQ4Ao3Oep3AHC8Xl2oh4mAxyJ3cIWDUwvaj5pcfxNb8zHd2mJ57t6msd/np3G7nSnAL267ZaPjaDObRlo3Akr7DfGr3fDSkOGI1PzXrFo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:reply-to:to:subject:mime-version:content-type; b=rMF7iEPmEGg8XfOgcBUAT6+gjVGg8pWjt8i7phTSaNBIWJcmf/5hsiG5vkucRh7pyTXZChtasbyt3r3W5wm0Em4EgYT2ijF0JNyB6TgWm6DfJLQV/PBi9RSMT01V2p/deZ3PByg5aUZM+IN7w2aT6VlDK0KfQvYSqDZ1/TqWf2o= Received: by 10.142.111.14 with SMTP id j14mr8141023wfc.96.1203632779650; Thu, 21 Feb 2008 14:26:19 -0800 (PST) Received: by 10.142.216.20 with HTTP; Thu, 21 Feb 2008 14:26:19 -0800 (PST) Message-ID: <91d5bf2c0802211426n52941904n114b80bf4bab31aa@mail.gmail.com> Date: Thu, 21 Feb 2008 19:26:19 -0300 From: "Lucas Sanabio" Reply-To: lucas@marx.com.br To: pgsql-admin@postgresql.org Subject: Table was deleted but it still been treated as not MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7159_33131213.1203632779649" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200802/254 X-Sequence-Number: 28328 ------=_Part_7159_33131213.1203632779649 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_7159_33131213.1203632779649 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_7159_33131213.1203632779649--