Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1trihz-00817V-0v for pgsql-general@arkaria.postgresql.org; Mon, 10 Mar 2025 19:22:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1trihx-00Gw6s-Gq for pgsql-general@arkaria.postgresql.org; Mon, 10 Mar 2025 19:22:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1trihx-00Gw6k-5Y for pgsql-general@lists.postgresql.org; Mon, 10 Mar 2025 19:22:37 +0000 Received: from mail-oi1-x22f.google.com ([2607:f8b0:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1trihv-0025Ga-13 for pgsql-general@lists.postgresql.org; Mon, 10 Mar 2025 19:22:36 +0000 Received: by mail-oi1-x22f.google.com with SMTP id 5614622812f47-3f6aab81647so1278336b6e.3 for ; Mon, 10 Mar 2025 12:22:35 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741634554; x=1742239354; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Xl+UODXftc75otO/TxjHPLmpcNmpFUkEhQBFDbtZ+w8=; b=b8lZfSi/K0M9jqR0D7EazHzqrqffSG+4YC3e5imV5BND0eo8VA+pT0J123yfuRNbjP 65T4/tpqTLPt+U3mW6CFn72oY9NuRY5QIoGzkPJeLHm3bI1Uf/l2/OSvzXtmKCMwELsU 2vnoMP9RbFXiJhI7GmMoEmroGdF8uNV1VOIdKglrvvR+WxoOWHmtZ74THAnnD7OyVqjQ E3VoEhxYjrOTAeS913ReB+11He0f0pc7i0LxWKaioRus+BGvhIFxTef610GJ7oUuVvmh 327XIO/GUWWVWRJNYLG3pbyvW3SchvlrNCwAmHZVFyscbXLutBnF6rN7sNiEUXBejypw 1R1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741634554; x=1742239354; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Xl+UODXftc75otO/TxjHPLmpcNmpFUkEhQBFDbtZ+w8=; b=LiTkBXrHdA/DdDdD9tPuf78q2/+PM88vSuGKgDxnlXDRn/8CFZsFWYpyPB45aqDVR9 mJjem2nWC+rhLGSV9F6nsHkckH/8/eYFItH/xIrSvv55r4dAuFmk6UgSWiUHBn3Cuqo7 cmhkSxyn/Opm8WPiu/s37a7M/GezShWpWNPyH3dYpmWlFiPC3mmcv1a10K/rqbzPuytX dUkWiJfS9kpz00g90m9fbJEhjGcNRCoWQv298DWLVCycnSGOriSOUEmsQcf/q9sCk6vE cGHkP2OhfSBpez89b/+6EciG0dG11UMzvRc3P/jWNsVMRfeFr/3v8IdZ72+w7xv//IZX sI1Q== X-Gm-Message-State: AOJu0Yx9lqJY6igbrJH/x4RPBwQKnFa/Hq3k1kJMhQbT+OuW8zfT14t/ UeNIwoDi9lSrDzRBR3Fu+mD7gXnbhU9vFk2Qa6jDZi/ucf2oxwqNvn8dRH2Iae0foAQq+SKfkZb PA3ualOtwc9tWfMFr/M6bGtDNypw= X-Gm-Gg: ASbGncs5aeopNpTNqcaNTy+8mI2DLsRoQQgou1UdzcbhlaSEMXKsqDI4QF0tGtu7hlE RH//Yi4U0xXi8S++Ft+uykRM671sJ3O8Cb/LtN8fbSSkptdp3k+Y8gTlAf7ncpBWk/D2ZffCwGB XQ/APMIo2KxUkOSiLUAEB8su18gXnmU/6lnNM= X-Google-Smtp-Source: AGHT+IH9tNgsadq39AMhqdwN/bkPaGHYcJhASYI4EXwCuE5cPxKJQ+3XpwIdF5sG0gqJlzTT8p4IZMLebZIV/Yuyb5w= X-Received: by 2002:a05:6808:3085:b0:3f7:e1f6:20a6 with SMTP id 5614622812f47-3f7e1f6225amr3326603b6e.0.1741634554337; Mon, 10 Mar 2025 12:22:34 -0700 (PDT) MIME-Version: 1.0 References: <84A5765B-1D3C-485B-B852-99D63D53963E@meddatainc.com> <4835994a-aecf-4fef-bb75-9a4c5f6e0ffd@aklaver.com> In-Reply-To: From: "David G. Johnston" Date: Mon, 10 Mar 2025 12:21:57 -0700 X-Gm-Features: AQ5f1JrtdRde-Fpw8O3dC_bd_rFMmgLy6-4COCPr90zuxT0Ma_e93umdecOIj7E Message-ID: Subject: Re: Creating files with testdata To: H Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000f0a005063001e4db" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f0a005063001e4db Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Mar 10, 2025 at 12:17=E2=80=AFPM H 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. --000000000000f0a005063001e4db Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Mar 10, 2025 at 12:17=E2=80=AFPM H <agents@meddatainc.com> wrote:
There are tables referencing each other u= sing randomly generated IDs, ie. those IDs are not known until after the pa= rent table row is inserted.

I just reserve half of the number space of b= igint, the negatives, for test data and assign known IDs as part of the tes= t data specification.

David J.

--000000000000f0a005063001e4db--