On March 10, 2025 3:21:57 PM GMT-04:00, "David G. Johnston" <david.g.johnston@xxxxxxxxx> wrote: >On Mon, Mar 10, 2025 at 12:17 PM H <agents@xxxxxxxxxxxxxx> wrote: > >> There are tables referencing each other using randomly generated IDs, >ie. >> those IDs are not known until after the parent table row is inserted. >> > >I just reserve half of the number space of bigint, the negatives, for >test >data and assign known IDs as part of the test data specification. > >David J. The finished application will also use UUIDs which is why am using it now.