Closed datarttu closed 3 years ago
Instead of route_ver_id, the exclusion constraint should use route and dir along with valid_during. We want that only one route & dir combo is valid at a time, and this is not guaranteed with the pkey whose value can be virtually arbitrary.
route_ver_id
route
dir
valid_during
route & dir
Instead of
route_ver_id, the exclusion constraint should userouteanddiralong withvalid_during. We want that only oneroute & dircombo is valid at a time, and this is not guaranteed with the pkey whose value can be virtually arbitrary.