Modify group_push_rules sync triggers

What does this MR do and why?

This modifies PostgreSQL triggers and functions that were added in !188143 (merged) to synchronize the group_push_rules table when there's a write operation on the push_rules table. The initial trigger didn't copy the id on the push_rules table to the group_push_rules and this led to out of sync data.

References

Screenshots or screen recordings

Before After

How to set up and validate locally

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #498935 (closed)

Merge request reports

Loading