On Mon, 10 Mar 2025 at 20:18, H <age...@meddatainc.com> 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.
Random? Then they CAN collide. ;-> Do the IDs need to be random or are they just the default value? I've encountered a similar problem with sequences and have bypassed it by using explicit values into the test data, i.e.m, inserting an invoice with id 1000 followed by its lines with IDs 100010, 100011, .... and then setting start_values for the sequences at 99999999. This helped me a lot in a debugging. You could do the same depending on what domain your random ids are on. Francisco Olarte.
