Re: Creating files with testdata

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: H <agents(at)meddatainc(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Creating files with testdata
Date: 2025-03-10 19:21:57
Message-ID: CAKFQuwbctBN=36TyZHkR5HCx=vvz2JRn54PFZy_7S_R7c3rYRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Mar 10, 2025 at 12:17 PM H <agents(at)meddatainc(dot)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.
>

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2025-03-10 19:22:41 Re: Creating files with testdata
Previous Message H 2025-03-10 19:15:10 Re: Creating files with testdata