PostgreSQL: Foreign keys with condition ON UPDATE CASCADE
Foreign keys are a key feature in Relational Databases, ensuring integrity and coherence of data. They allow doing transactions ON CASCADE, which means that changes on the primary key/unique constraint they reference is also…