gforien opened a new issue, #21950: URL: https://github.com/apache/superset/issues/21950
## Context On Superset v1 with a pgsql database, I need to delete a database. I didn't find a way to do it on the UI or in the documentation, so I connected to the superset internal DB and tried to delete it directly. What am I doing wrong ? #### How to reproduce the bug 1. `pgsql postgres://name:pass@host:5432` 2. `superset=> DELETE FROM public.dbs WHERE id=xx;` ### Expected results Cascading delete on other tables allows to delete a row from the `public.rds` table. ### Actual results ``` ERROR: update or delete on table "dbs" violates foreign key constraint "query_database_id_fkey" on table "query" DETAIL: Key (id)=(xx) is still referenced from table "query". ``` ### Environment - superset version: `1.5.0` ### Checklist - [x] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [x] I have reproduced the issue with at least the latest minor released version of superset. - [x] I have checked the issue tracker and the discussions for the same issue and I haven't found one similar. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
