From: | "Lucas Sanabio" <lsanabio(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, Decibel! <decibel(at)decibel(dot)org> |
Subject: | Re: Table was deleted but it still been treated as not |
Date: | 2008-02-22 15:02:58 |
Message-ID: | 91d5bf2c0802220702r355fc2f7l88f22a86eb5baa39@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)marx(dot)com(dot)br
Tel: (62) 3281-9889 ou (62) 8117-5266
On Fri, Feb 22, 2008 at 8:14 AM, Decibel! <decibel(at)decibel(dot)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(at)marx(dot)com(dot)br
> > Tel: (62) 3281-9889 ou (62) 8117-5266
> >
> > On Thu, Feb 21, 2008 at 8:32 PM, Decibel! <decibel(at)decibel(dot)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(at)decibel(dot)org
> > > Give your computer some brain candy! www.distributed.net Team #1828
> > >
> > >
> > >
>
> --
> Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
> Give your computer some brain candy! www.distributed.net Team #1828
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-02-22 15:44:30 | Re: Stray autovacuum daemon |
Previous Message | Tom Lane | 2008-02-22 14:54:15 | Re: PL/pgSQL memory consumption? |