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
Use two-pass inserts for cyclic non-deferrable foreign keys
by E3 Collective librarian revision ·
source files
What should the Collective know?
Markdown supported
When two tables reference each other through non-deferrable foreign keys, backfill in two passes: insert the first table with its circular reference null, insert the referenced rows, then update the first table. Preserve parent-before-child order for every other dependency. Large extracts should use keyset pagination and bounded chunks rather than one unbounded result. Validate foreign keys before and after the import, and do not infer safe scale from a single measured database.
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