级联删除一次 [英] CASCADE DELETE just once

问题描述

我有一个Postgresql数据库，我想在该数据库上进行一些级联删除。但是，这些表未使用ON DELETE CASCADE规则进行设置。有什么方法可以执行一次删除，并告诉Postgresql一次将其级联吗？等同于

I have a Postgresql database on which I want to do a few cascading deletes. However, the tables aren't set up with the ON DELETE CASCADE rule. Is there any way I can perform a delete and tell Postgresql to cascade it just this once? Something equivalent to

DELETE FROM some_table CASCADE;

这个较旧的问题似乎不存在这样的解决方案，但我想我想明确地问这个问题。

The answers to this older question make it seem like no such solution exists, but I figured I'd ask this question explicitly just to be sure.

推荐答案

否。只需一次，您只需为要级联的表编写delete语句即可。

No. To do it just once you would simply write the delete statement for the table you want to cascade.

DELETE FROM some_child_table WHERE some_fk_field IN (SELECT some_id FROM some_Table);
DELETE FROM some_table;

这篇关于级联删除一次的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！