Define id trigger on p_ci_builds table
In !125002 (comment 1488513574) we're adding the triggers to populate the id column on p_ci_builds
partitions instead of the routing table because on PG12 we can't have before insert
triggers on partitioned tables. After we switch we to PG13+ and support for PG12 is removed, we should move the triggers to the routing table.
The following discussion from !125002 (merged) should be addressed:
-
@mbobin started a discussion: (+2 comments) I don't think we have to wait until the database upgrade is completed since it will be done in steps for each db and it could take more months. We can add the trigger on each partition and later we will move it on the partitioned table.
I don't think that we'll need to create a third partition soon.