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(dot)klaver(at)aklaver(dot)com