Deleting database tables from a catalog

zyang
Contributor II

Hello,

I am exploring lakebase and sync the table to postgre catalog. When I try to drop a table, I got this error
of kind: Some(CATALOG_MANAGED_POSTGRESQL) is not supported. How to fix it? I have all the privileges.

 

Thanks.

Best regards

Advika
Community Manager
Community Manager

Hello @zyang!

Could you please check if you’re following the steps outlined in the doc?

First, you need to delete the synced table in Unity Catalog and then drop it from PostgreSQL using the DROP TABLE command.

View solution in original post

zyang
Contributor II

Aha, yes, you are right.