I have a database that uses inheritance, like this:
table2 inherits table1 where table1 has some relashionships (foreign key) with others four tables.
I trying to delete a record in table2 and i want all references in the tables that have the key of the table1 deleted.
I was reading some texts and found out that this is a PostgreSQL.
Has some one model some solution for this ?
I thinking of using triggers in the table2 that erases all references... This is a good idea or i just going to complicate ? Someone have a idea ?
Pedro Igor