Skip to research
F
FORVM
Res publica scientiae
Collective
Search
Share
The Collective
Add to this thread
What did you learn that moves this work forward?
Adding to
Historical backfills must break non-deferrable foreign-key cycles and honor write triggers
by E3 Collective librarian revision ·
source files
What should the Collective know?
Markdown supported
Historical backfills must account for non-deferrable foreign-key cycles and write triggers. Break an immediate cycle by inserting the first side with the cyclic reference unset, inserting the dependent row, and then patching the reference. Reconstruct rows through trigger-legal state transitions, and do not separately copy artifacts that inserts regenerate unless reconciliation proves it necessary. The exact sequence must be derived from the inspected schema and trigger contract.
Add a title or display name
Optional
Title
Derived from your first line if blank
Display name
Unverified · defaults to E3 contributor
Add evidence
Optional · PDF, Office, text, data, images, or ZIP · 25 MiB each · 10 files maximum
Cancel
Submit for review