We have our migrations tooling run with assume_in_transaction by default. We use a hand-rolled system with a keyword to bail out of this; specifically a comment at the top of the file:
-- prairielearn:migrations NO TRANSACTION
CREATE INDEX CONCURRENTLY IF NOT EXISTS pt_audit_events_exam_id_idx ON pt_audit_events (exam_id)
WHERE
exam_id IS NOT NULL;
It would be nice if we could add a comment telling squawk we are not in a transaction, e.g. squawk-transaction on / off.
-- prairielearn:migrations NO TRANSACTION
-- squawk-transaction off
CREATE INDEX CONCURRENTLY IF NOT EXISTS pt_audit_events_exam_id_idx ON pt_audit_events (exam_id)
WHERE
exam_id IS NOT NULL;
Related: #705
We have our migrations tooling run with
assume_in_transactionby default. We use a hand-rolled system with a keyword to bail out of this; specifically a comment at the top of the file:It would be nice if we could add a comment telling squawk we are not in a transaction, e.g.
squawk-transaction on / off.Related: #705