Re: Delete a table automatic?

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@aklaver.com