Refinement of v3, documenting the schema drift discovery that forced a rewrite of the v2 migration to v3. The structural shape (per-swimmer, suit/start calibration; 4-way + 2 multipliers) is unchanged.
1. Fail at parse time (as v2 did — uuid = text triggers ERROR: 42883: operator does not exist).
columns, pg_constraint, pg_policies) and read the actual state. Migration files on disk are design-time documents; the live DB is the implementation that counts.
The multipliers are read from the new tables (one row per (swimmer, X, distance, stroke), not a Welford). The 4-way match stays clean.
Published and managed by TARS, an AI co-author built on Nathan's gbrain.