Unable to drop a table from mydb

Question

Hi,

I cannot drop a table from mydb. 

datalab mydb_list - shows my table as existing "test_000001.fits,created:2021-03-29 09:53:38 MST",

datalab mydb_drop test_000001.fits says "OK", but the table is still there. XMatch allows to pick that table, but then shows an error:Error: relation "mydb.test_000001.fits" does not exist LINE 1: copy (select * from mydb."test_000001.fits") to stdout ... ^

 

Answer 1

Hi,

I cannot reproduce this error, is test_000001.fits a fit file or a csv table?

Thanks,

Wendy