Project push rules: [STEP 0] Remove sync triggers for push_rule_id column from namespaces table
Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.
Implementation plan
| Step | Action | Release |
|---|---|---|
| 0 | Project push rules: [STEP 0] Remove sync trigge... (#539211) | Release M |
| 1 | Project push rules: [STEP 1] Ignore `push_rule_... (#535966) | Release M |
| 2 | Project push rules: [STEP 2] Drop `push_rule_id... (#535967) | Release M+1 |
| 3 | Project push rules: [STEP 3] Remove ignored `pu... (#535968) | Release M+2 |
This issue is to execute the step 0 of this plan.
Context
When we eventually plan to drop the push_rule_id column from the namespaces table, we need to remember to drop the synchronization triggers first. The current triggers (which sync from push_rules to group_push_rules tables) maintain a 1:1 relationship, ensuring each group has at most one record in the group_push_rules table.
If we were to nullify or drop the push_rule_id column without first removing these triggers, it would cause the deletion of all corresponding group_push_rules records due to the DELETE action in the trigger.
Original comment: &16895 (comment 2480909354)
Edited by 🤖 GitLab Bot 🤖