Files
silo-server/migrations/sql/20260806120421_validate_playback_v3_frozen_recipe.sql
fa1d7ba2b4 fix(playback): freeze v3 seek reanchor recipes (#548)
* fix(playback): freeze v3 seek reanchor recipes

* fix(playback): address v3 recipe review feedback

* test(playback): isolate v3 fallback route fixture

* fix(database): split v3 recipe constraint validation

* fix(playback): preserve frozen seek recipe identity

---------

Co-authored-by: Quick104 <31828688+Quick104@users.noreply.github.com>
2026-08-06 10:43:21 -04:00

9 lines
288 B
SQL

-- +goose Up
ALTER TABLE playback_v3_attempts
VALIDATE CONSTRAINT playback_v3_attempts_frozen_recipe_object;
-- +goose Down
-- PostgreSQL cannot mark a validated CHECK constraint NOT VALID again. The
-- preceding migration's Down step drops the constraint with its column.
SELECT 1;