Adrian Klaver <adrian.klaver@xxxxxxxxxxx> writes: > On 10/31/22 18:44, 黄宁 wrote: >> I now have two tables named A and B. Table B is calculated based on the >> data of table A. I wonder if table B can be automatically deleted when >> table A is deleted？ > The only thing I can think of is a sql_drop event trigger: I wonder whether the OP's purposes wouldn't be better served by making B a view or materialized view, instead of a separate table. Then the cascaded-drop behavior would be automatic. regards, tom lane
