PostgreSQL: cascade delete on bidirectional references only for source column
I have tables variable and variable_variable. The last one holds 2 columns: variable_id_from variable_id_from Look at the schema below: If variable_variable has row with values {variable_id_from = 1, variable_id_to = 2}, it means that variable with id = 1 references…