On March 10, 2025 3:27:02 PM GMT-04:00, Francisco Olarte <folarte@peoplecall.com> wrote:
>On Mon, 10 Mar 2025 at 20:18, H <agents@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.
K am using UUIDs which the application will use as well.
