[MonetDB-users] Can't drop "global temporary table" in SCHEMA tmp
Hi guys,
I got a problem when I trying to drop a global temporary table in my database, I got following errors:
sql>drop table tmp.test; 42S02!DROP TABLE: no such table 'test'
I got the same error as above when I trying to execute a "select" query on that table, It's so weird, cause the table "test" was been there:
sql>\d TABLE tmp.test
The even more weird things happened when I execute following command:
sql>create global temporary table tmp.test(id int); operation successful (1.888ms) sql>\d TABLE tmp.test sql>\d test table tmp.test is not unique, corrupt catalog? sql>\d TABLE tmp.test sql>drop table tmp.test more>; operation successful (1.470ms) sql>\d TABLE tmp.test
Please pay attention on this line "table tmp.test is not unique, corrupt catalog?".
Do anybody can help me out of here?
Thanks, Tony
participants (1)
-
bai dongli