Postgres Pro
Downloads
Home   >   mailing lists

Re: Table exists but can't drop. - Mailing list pgsql-novice

From Tom Lane
Subject Re: Table exists but can't drop.
Date
Msg-id 11873.1215012357@sss.pgh.pa.us
Whole thread Raw
In response to Table exists but can't drop.  ("Ridvan Lakas ng Bayan S. Baluyos" <ridvan@baluyos.net>)
List pgsql-novice
Tree view 
"Ridvan Lakas ng Bayan S. Baluyos" <ridvan@baluyos.net> writes:
> I have a weird problem. When I'm describing a table, I can see its table
> structure. However, when I try to drop/select the table. It says that the
> table doesn't exist.

Bizarre.  What PG version is this?  Can you SELECT from that table?
Could we see the results of
    select ctid, xmin, xmax from pg_class where relname = 'gtmonitor2'

            regards, tom lane

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Calculating repeating events - functionality lost with the demise of tinterval ?
Next
From: Daniel
Date:
Subject: Re: Calculating repeating events - functionality lost with the demise of tinterval ?