Horton
Menu

Re: Creating files with testdata

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: H <agents@meddatainc.com>
Cc: pgsql-general@lists.postgresql.org
Date: 2025-03-10T19:21:57Z
Lists: pgsql-general 
On Mon, Mar 10, 2025 at 12:17 PM 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.
>

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.