The method add_concurrent_foreign_key does not take care of this so you'll need to do so manually. Every foreign key must define an ON DELETE clause, and in 99% of the cases this should be set to ...

If you have a foreign table in PostgreSQL and you use dBeaver to add a new column, alter an existing column, etc. it fails because dBeaver apparently doesn't know how to generate the proper SQL ...