Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DDFF62E00F2 for ; Fri, 22 Feb 2008 11:03:10 -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 41397-05 for ; Fri, 22 Feb 2008 11:02:54 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.224]) by postgresql.org (Postfix) with ESMTP id 357872E00E1 for ; Fri, 22 Feb 2008 11:03:01 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 71so799823wri.5 for ; Fri, 22 Feb 2008 07:03:00 -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:in-reply-to:mime-version:content-type:references; bh=0n9qvr2pDKDpk83ji478nu402C/zifhhvr5oDMykweU=; b=vCq7IciWwuD/POPYbs9Zer7l+EC5na1cHzFnJbLXeU6tLpuoxRgHKojvbOIKNq7OqlFtCU7vlgX8/lKtYaQuMOPW6uuV6w71brY5blTRopdKJs5LNnlg5IKDIitzUaEO9KQf49zQVgLxxWpp6nVyiDCXK/WroX1j6t6SPfJmYGE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:references; b=vkLcJpOiZZfjQ691kcxj/x/fzBbeRumlrH1Gvlc2uwgzgBPwWL9NktY2/CmHmVd1GXmCvbRZyXJJvXI7eWfTILZ+EaInW6JtdcOmVggc7oHZ0tN0OzS/9O6GNnaW9yqiGPSN8etJaL09Ylq66KlZEL0OYB90ub/KGl/Em4OvYB0= Received: by 10.141.99.4 with SMTP id b4mr8033rvm.270.1203692578543; Fri, 22 Feb 2008 07:02:58 -0800 (PST) Received: by 10.141.203.4 with HTTP; Fri, 22 Feb 2008 07:02:58 -0800 (PST) Message-ID: <91d5bf2c0802220702r355fc2f7l88f22a86eb5baa39@mail.gmail.com> Date: Fri, 22 Feb 2008 12:02:58 -0300 From: "Lucas Sanabio" Reply-To: lucas@marx.com.br To: pgsql-admin@postgresql.org, Decibel! Subject: Re: Table was deleted but it still been treated as not In-Reply-To: <20080222111439.GX1212@decibel.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_692_14300215.1203692578541" References: <91d5bf2c0802211426n52941904n114b80bf4bab31aa@mail.gmail.com> <1C10A4FE-D20C-4BD2-A612-E27414BB7B5D@decibel.org> <91d5bf2c0802211637uf7b1b9wf2181749a988fea1@mail.gmail.com> <20080222111439.GX1212@decibel.org> 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/276 X-Sequence-Number: 28350 ------=_Part_692_14300215.1203692578541 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Doing it by the psql the comand DROP TABLE vendas_item_orcamento; Message: ERRO: table "vendas_item_orcamento" doesnt exist. The \d vendas_item_orcamento; Message: Didn't find any relation called "vendas_item_orcamento". Any ideas? -- 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 On Fri, Feb 22, 2008 at 8:14 AM, Decibel! wrote: > Yes. And see what \d tablename shows. > > On Thu, Feb 21, 2008 at 09:37:19PM -0300, Lucas Sanabio wrote: > > I'm sorry, but what do you mean? Try to delete it using psql? > > > > 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 > > > > On Thu, Feb 21, 2008 at 8:32 PM, Decibel! wrote: > > > > > 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 > > > > > > > > > > > -- > Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org > Give your computer some brain candy! www.distributed.net Team #1828 > ------=_Part_692_14300215.1203692578541 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Doing it by the psql the comand

DROP TABLE vendas_item_orcamento;
Message: ERRO: table "vendas_item_orcamento" doesnt exist.

The \d vendas_item_orcamento;
Message: Didn't find any relation called "vendas_item_orcamento".

Any ideas?

--
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

On Fri, Feb 22, 2008 at 8:14 AM, Decibel! <decibel@decibel.org> wrote:
Yes. And see what \d tablename shows.

On Thu, Feb 21, 2008 at 09:37:19PM -0300, Lucas Sanabio wrote:
> I'm sorry, but what do you mean? Try to delete it using psql?
>
> 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
>
> On Thu, Feb 21, 2008 at 8:32 PM, Decibel! <decibel@decibel.org> wrote:
>
> > 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
> >
> >
> >

--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828




------=_Part_692_14300215.1203692578541--