Skip to content

Draft: migrations: Ignore repository_id in UPDATE trigger

Toon Claes requested to merge toon-no-trigger-repoid into master

The 20210906145021_link_repository_id migration touches all rows in storage_repositories. This causes the TRIGGER ON UPDATE on that table to pass a very large payload to pg_notify when there a lot of repositories known to Praefect.

This change modifies that TRIGGER to exclude changes that only touch the repository_id.

Closes: #3806 (closed)

Edited by Toon Claes

Merge request reports