Thread: Table exists but can't drop.
Hi all,
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.
I checked the rights of the user and only found out that I only have 2 users for the database. I tried to login as user `postgres` and tried to drop it again. But still it says that the relation doesn't exist.
pos=# begin;
BEGIN
pos=# \d gtmonitor2
Table "public.gtmonitor2"
Column | Type | Modifiers
-----------+---------------+-----------
pos | integer | not null
dt | date | not null
oldgt | numeric(16,4) | not null
newgt | numeric(16,4) | not null
txnamount | numeric(16,4) | not null
txncount | integer | not null
zcount | integer | not null
opencount | integer | not null
pos=# drop table gtmonitor2;
ERROR: table "gtmonitor2" does not exist
pos=#
What could the problem be?
Thanks in advance!
Ridvan
--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos
Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.
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.
I checked the rights of the user and only found out that I only have 2 users for the database. I tried to login as user `postgres` and tried to drop it again. But still it says that the relation doesn't exist.
pos=# begin;
BEGIN
pos=# \d gtmonitor2
Table "public.gtmonitor2"
Column | Type | Modifiers
-----------+---------------+-----------
pos | integer | not null
dt | date | not null
oldgt | numeric(16,4) | not null
newgt | numeric(16,4) | not null
txnamount | numeric(16,4) | not null
txncount | integer | not null
zcount | integer | not null
opencount | integer | not null
pos=# drop table gtmonitor2;
ERROR: table "gtmonitor2" does not exist
pos=#
What could the problem be?
Thanks in advance!
Ridvan
--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos
Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.
"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