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 1trkOl-008uFo-8t for pgsql-general@arkaria.postgresql.org; Mon, 10 Mar 2025 21:10:55 +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 1trkOj-000PMh-PA for pgsql-general@arkaria.postgresql.org; Mon, 10 Mar 2025 21:10:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1trkOj-000PMZ-ES for pgsql-general@lists.postgresql.org; Mon, 10 Mar 2025 21:10:53 +0000 Received: from mout.perfora.net ([74.208.4.194]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1trkOf-0026tJ-2t for pgsql-general@lists.postgresql.org; Mon, 10 Mar 2025 21:10:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=meddatainc.com; s=s1-ionos; t=1741641050; x=1742245850; i=agents@meddatainc.com; bh=6sNbu9bI4/BYRSn/Srb33Y2zU1me2zHak5jx5A0knQA=; h=X-UI-Sender-Class:Date:In-Reply-To:References:MIME-Version: Content-Type:Content-Transfer-Encoding:Subject:To:From:Message-ID: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=nQwhXvaCriOQolLf4pU8LxLPc+z3lhQn1OTygDYjLUaR+qORH7B8SPf56N9gVvYt FsYU9V9sWW7SIjL0EGQv16Qm1VB69wp1zs3b6j47a2xh2ow5q+/MxE4QImN+ovyqj dFpnVwjZYB39l3VnM7peWn9LYp1tLJqREB12xjBxWJsz+gOMzW5oEshmX6xq65oPs 83ds+4NG8xxQGiJ0EPmiNJqQTbZrY4HPOmkz+vRrPSUif34OuthtcyQC9z3Lv2Kjl +nRDjI2GR6pJTDzeCXTT35uQ9rlVxg3/vYjE/iKhkEJkteLdwom6CAYvmE7J6ett3 EYhO0ur+RZ011L/e3w== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from [192.168.106.147] ([96.245.190.98]) by mrelay.perfora.net (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0MehX4-1tcGq92vIe-00P6Z5 for ; Mon, 10 Mar 2025 22:10:49 +0100 Date: Mon, 10 Mar 2025 17:10:44 -0400 User-Agent: K-9 Mail for Android In-Reply-To: References: <84A5765B-1D3C-485B-B852-99D63D53963E@meddatainc.com> <4835994a-aecf-4fef-bb75-9a4c5f6e0ffd@aklaver.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Subject: Re: Creating files with testdata To: pgsql-general@lists.postgresql.org From: H Message-ID: <117C855F-6FFE-433B-AA30-2EE095FE0F35@meddatainc.com> X-Provags-ID: V03:K1:8FagcP6u14vk1CzIQtC3VpDNHZ9Q677AN+0U5N2dE9JC7r4aee4 qcnM6KmQey90FsTfrOAXXC76AtnWqb5yHDjGT58CtoIn2UgujUPkIMl+gP1/yJWGz4My9WC i8z+qBIsPONbj/JtOL2D/7DY4j0jgJKoH7VFB5Hixfu/JoyaXcv1Ml9qkqPadj3NKLpcntN Qni6Q7tvYObfspo9xWt/g== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:tMM9UW3fQho=;AeQ6BYoPrPqTyaaY9E0DpJG1klF z6MymFfaixlzqRXmo+7es1OQFUtHzjebfJJyewNgpA0u9yuRJoIFq7aCxQmLY3jU6ncn/CfEl Y7Fgm72QaMXiveYnW6N5lx8C8nWsYLerTARFlATwquWtfTuruh1la5btc5QTI/FL8d+efNNOh 3dhUOZu3R9nz/4K3gbfkAZTLMs3S8Lz6ze2tfqzRQJIlHNLE+dCZa1OeNTNpAJ9n1XeukkiOp DmZPvf+C/NaboocgtO/0evGP+sEfq8H2p2W6+sAikpRdQQ7FoR9LCnV5xf8UchZPkkNVcU155 cKwr6O2MToD/xwIF6KdYxu88UsrBBSB7yE/6IonWmp+oDy+4KRIktwWiKSWERCdt+ZPZVeL2X 6d2cwm9AQ3RkdnqyQ8zw17kUVkPVWiRIF62UDG4YlHLIUhQPLfgB70JNWaHKVy//h58amL7vd BmYyTklOhDavy2Tyewh0mqpWngoI/RAC+rwU4czlsjXaiRB3gK68debxE9UpuBBgxs75H3tm1 zXd/BVXDZ/3uQmpgXvC6kIZcO9VEpDvAQLJoYJSJEGyK09xMQvo5p6B9JMhCmOEo+TS0IDdEP xbMwpSdtsbRWtpOWG0y+jKRDOij2a1HJ8pJ6DymXRVhCW5olDlGoyXwGJcOTEPQGltE6MfA+X Tm0bImJhljdT+B/uruxxXqtPf8jvx4oAb9AtqoVVYjUw1v0bRKb4AV0wHKSf4vNSY702jpKGR QQsrToc4xSViE71CLt1IQgJBde4+leYmZo5qZJ9UJCVh+4/fT0HvPzkkNS7jVYPnPaZ6Crwmf 9hpJiRE4rFlIcgm6F4GwAU5c2lVWYhqIRO9xXN5V/DshoLC8V4yXS00dia1MC0v5/KBLg9KzO sj+JYax4+rOjrkXLFBsR5jmflDyl0wKcyTE706JW2xRL9h3TacdlnCC2jiR6DO8Bv5uY+QZyy sRSsyVkPzZbXjwF0SCLuZFK396p3f3M6ldWrmVle4iWLei1aSTukKhiLd6O9L6MfVO/vV02W7 auhBXtvX0pQ0O3nsoedn4Xsug/H4lWGNGXrA5th29HrXHzARWRIqf/TXsWlBOu9KVXpfK7cW0 JLWLDuyUgEDWTUwQ7AhWGveEq6446rVW0j6Z6HJrx4YwtBVtClcR3HmDoeEGaYe8lrgo7K7sp O7LQ7HG8Tx5bOYSZ5I2tf4BW2mrxbuMkjsUvytIHtjqazPJdB4TOJ7SpY9KjfoAtF+5YBFWl6 TpePsNjHLgypKhEdF9uTlFIMkAmO2lMRbstPMbza7MfJAgD1GVFz0iuD39mZk5/cysE9+ZtUv G/HvpImqu3jofFacStVBmL7ONfVucmhGvZnGHmIYOu6Dwn55Wq16O5dxU/Baw5mrAdo List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On March 10, 2025 3:21:57 PM GMT-04:00, "David G=2E Johnston" wrote: >On Mon, Mar 10, 2025 at 12:17=E2=80=AFPM H wrot= e: > >> There are tables referencing each other using randomly generated IDs, >ie=2E >> those IDs are not known until after the parent table row is inserted=2E >> > >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=2E > >David J=2E The finished application will also use UUIDs which is why am using it now= =2E