You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/10/27 08:22:54 UTC
[GitHub] [superset] gforien opened a new issue, #21950: No cascading delete for table `public.dbs`
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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] No cascading delete for table `public.dbs` [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #21950: No cascading delete for table `public.dbs`
URL: https://github.com/apache/superset/issues/21950
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] No cascading delete for table `public.dbs` [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #21950:
URL: https://github.com/apache/superset/issues/21950#issuecomment-1939775204
Closing this as stale since it's been silent for so long (we no longer support 2.x or prior), and we're trying to steer toward a more actionable Issues backlog. If people are still encountering this in current versions (currently 3.x) please open a new Issue or a PR to address the problem.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org