Обсуждение: 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@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

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