Home > mailing lists

Re: Creating files with testdata - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: Creating files with testdata
Date	March 10 22:21:57
Msg-id	CAKFQuwbctBN=36TyZHkR5HCx=vvz2JRn54PFZy_7S_R7c3rYRQ@mail.gmail.com Whole thread Raw
In response to	Re: Creating files with testdata (H <agents@meddatainc.com>)
Responses	Re: Creating files with testdata
List	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.

From: H
Date: 10 March, 22:15:10
Subject: Re: Creating files with testdata

From: Francisco Olarte
Date: 10 March, 22:22:41
Subject: Re: Creating files with testdata