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: https://www.postgresql.org/docs/current/functions-event-triggers.html#PG-EVENT-TRIGGER-SQL-DROP-FUNCTIONS 9.29.2. Processing Objects Dropped by a DDL Command Though this will not be specific to one table. -- Adrian Klaver adrian.klaver@xxxxxxxxxxx
