If you mean you have a foreign key in table B pointing to the row in table A. Then you delete the row in table A, you don't want to use cascade delete to delete the row in table B? You have to do something with the foreign key, either delete the row or null the foreign key entry out. https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-foreign-key/ shows a way to null the foreign key instead of deleted the row.