pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Table was deleted but it still been treated as not
4+ messages / 2 participants
[nested] [flat]

* Table was deleted but it still been treated as not
@ 2008-02-21 22:26 Lucas Sanabio <lsanabio@gmail.com>
  2008-02-21 23:32 ` Re: Table was deleted but it still been treated as not Decibel! <decibel@decibel.org>
  0 siblings, 1 reply; 4+ messages in thread

From: Lucas Sanabio @ 2008-02-21 22:26 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Table was deleted but it still been treated as not
  2008-02-21 22:26 Table was deleted but it still been treated as not Lucas Sanabio <lsanabio@gmail.com>
@ 2008-02-21 23:32 ` Decibel! <decibel@decibel.org>
  2008-02-22 00:37   ` Re: Table was deleted but it still been treated as not Lucas Sanabio <lsanabio@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Decibel! @ 2008-02-21 23:32 UTC (permalink / raw)
  To: lucas@marx.com.br; +Cc: 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@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Attachments:

  smime.p7s (application/pkcs7-signature, 2.5K) download

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Table was deleted but it still been treated as not
  2008-02-21 22:26 Table was deleted but it still been treated as not Lucas Sanabio <lsanabio@gmail.com>
  2008-02-21 23:32 ` Re: Table was deleted but it still been treated as not Decibel! <decibel@decibel.org>
@ 2008-02-22 00:37   ` Lucas Sanabio <lsanabio@gmail.com>
  2008-02-22 15:02     ` Re: Table was deleted but it still been treated as not Lucas Sanabio <lsanabio@gmail.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Lucas Sanabio @ 2008-02-22 00:37 UTC (permalink / raw)
  To: Decibel! <decibel@decibel.org>; +Cc: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Table was deleted but it still been treated as not
  2008-02-21 22:26 Table was deleted but it still been treated as not Lucas Sanabio <lsanabio@gmail.com>
  2008-02-21 23:32 ` Re: Table was deleted but it still been treated as not Decibel! <decibel@decibel.org>
  2008-02-22 00:37   ` Re: Table was deleted but it still been treated as not Lucas Sanabio <lsanabio@gmail.com>
@ 2008-02-22 15:02     ` Lucas Sanabio <lsanabio@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Lucas Sanabio @ 2008-02-22 15:02 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org, Decibel! <decibel@decibel.org>

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
>

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2008-02-22 15:02 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-21 22:26 Table was deleted but it still been treated as not Lucas Sanabio <lsanabio@gmail.com>
2008-02-21 23:32 ` Decibel! <decibel@decibel.org>
2008-02-22 00:37   ` Lucas Sanabio <lsanabio@gmail.com>
2008-02-22 15:02     ` Lucas Sanabio <lsanabio@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox