Sign in or sign up before continuing. Don't have an account yet? Register now to get started.
Register now

Add trigger to update issues.correct_work_item_type_id whenever issues.work_item_type_id is changed

While we transition into a different foreign key issues.correct_work_item_type_id we need to make sure this new column is updated with the correct value whenever the original FK is changed issues.work_item_type_id. With this, we can already add a NOT VALID FK to the column and backfill every issues record in a next step

Edited Sep 27, 2024 by Mario Celi
Assignee Loading
Time tracking Loading