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 1trkKu-008sc4-Oc for pgsql-general@arkaria.postgresql.org; Mon, 10 Mar 2025 21:06:56 +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 1trkKt-000D0j-GF for pgsql-general@arkaria.postgresql.org; Mon, 10 Mar 2025 21:06:55 +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 1trkKs-000Cxn-Uw for pgsql-general@lists.postgresql.org; Mon, 10 Mar 2025 21:06:55 +0000 Received: from mout.perfora.net ([74.208.4.196]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1trkKq-0025yq-2W for pgsql-general@lists.postgresql.org; Mon, 10 Mar 2025 21:06:53 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=meddatainc.com; s=s1-ionos; t=1741640812; x=1742245612; i=agents@meddatainc.com; bh=TMF/VCMGgwULyWOEfCfBDAfhlkUODYxgYOTVpWDdZxY=; 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=c/tupT0uc6GgzAJmOXZb5sEjHGtaJ0/fWMLY3UPvtYkKhwjFnL+k78PSzaycCD4o 6M9YURskoyeu2BpSVpHZ/O3QijyA4yTAL7OD6vDqzDUeLltd6STuiR0fLbO8vLsQI dO/7qSxzU+4qjiz8VijJFSRrOUqokWv4jQ9xf/9eLhLLXlXMMyHuPg58Z0mvxVX0/ Wj+VPpz/+cDVxz+wgh/UNHKCcv4PEpv0ANP/zIx7L/2rrMfr0HyMn+B14lV6CU0vv BPd7gTopm7aGcrWUPUalhgL3Tgu6J1vSexp8930epihX8KVT1eqUvBnmc61+TuuEc 7YWZ7XeE7ipTpVwUfg== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from [192.168.106.147] ([96.245.190.98]) by mrelay.perfora.net (mreueus002 [74.208.5.2]) with ESMTPSA (Nemesis) id 0M9ZXN-1twSkm28fn-007VwQ for ; Mon, 10 Mar 2025 22:06:51 +0100 Date: Mon, 10 Mar 2025 17:05:13 -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: X-Provags-ID: V03:K1:bedNpA+XCOlRS2tBDb0QOckpv047i4Y9uCEApolS054YiuebYhp j0GG4Tcje3PCvPU/HZSfaRC6BSJkonv1vJMGSAmpExeLmYKco9gQmirl/GELoTYLF1ij0+J eL682iQXavMsKeolrwk+i3YdjTCAlD3MnNYExXY+q+Pc8hM5jr3KbqUPPqudHFgQWaF9krO 34d6hPAeZYjL6grLBLRxA== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:zmG7Mfreabg=;zbOpk2JbRzaymk63UYjEFR/7oXc MYJPQ7gIQSroqNof7B4cZMzfwDTBzZvhNvEPqyXJ5Azi43S2866LjTJxdmPKdU/D53U5S2Y1y ar4pqdQkgnpq4Vf+mJOamcOa6TSqYT/0umV/84TgKp8CcQOWxLzdRyrlaLR+anCohv6a6usL6 /L3GxN92AoVxsRngGCB3949kQFaH2txa4zCeiRcnp8vy5hDxXgkgNxqJy5ASiWUYCOahu9uD8 iMxBgF+suJ2g22kAuDMimQ9ntE6fsusbqomRNwK+ZAqCmetdDpzXITm+vKVDbXsaMAEOh4g5Q yA25wSKyCuxftsh7w9e0LKD4QTWyCzTeCfFSz390YWUR0Wt4X1HknnFnXVK+hkZrcQtVLmZpJ k78gAYiiMlbFuoenzu56cps65pzEaR6aWHQKOqZME8rmEmGOTcKR+g7ITBD2WYu3v1Mt5tHJ1 dNmT4dAGxJS1DyTW5wys9b3OPgeCguCXhrrZYjaPNmz5jVCLNi3UIFRE1cJ3z6/khTeDzYQqq LofTOk6Dc9qP6WsbPzMweZPFFnZNKNivnKahYlrHqlQJYWj0h+A9z+GsjRqWN+UkZ4spITGOx +ym//4VNgtoybVJnu8hIYAlOl2pybjkwweufcQaaSrlANkoN4yd52jUhkfdnryuDl5O3XPLyS uqeKsjmElR+djmrvBMTE1cZ+wA+EMxQhtdI0tAhPmK0O8PGwHqIXEBVx2lKFQCEJe28k+bvyI f6nkHfMYDBbAl45+RoschQ+EgGecWTusnFkzhB/NVnO1iQqk/Xe7WSVT9A8WT/0lXyPCvs00J W9x5FJzJgA9HXi9ni094NJxg7oiOPH8vXbOXHIbvfRgHFUk+NGCcNATboyw1GTsDHD277Yu+9 pdDzdlULqQhpKrsSWgcOePdsT+Z6AP0pQzXOsyp8q9dgbn8oDb8J4RYR801cs9RL2ervhAirt QtL9+bPkMMVUSjlqaZk2tmmGLA7m4ZKQsDqFs2vQkE/y0EwkFQuCaZMcyI8Ki4Jz/skm5YWwU epJjg419Nlt1h4vOTzVkiqAyhXw/dPJzh5f8KGc8nHuRF6bEIhKgwW6WwcrLfl+YktAeyi4Fi 295/HFiyXhsSmAALjPsG3zkoFEoVIjWN0bZYnGiqYLiaRrR9LqnK0VOwEysWCqubAwfumWera gPFye8jJz3jQpsfiD3nIA5VAfjhxgStwsS8uy51Tau/eaM5PVxhlM6LS9wjWxzou8/ccqn0xk D6gihS/G1LVDiFbD/+IkJEAXfTsvbdLdbyvaFzMUaUDuFN+uXlOwNNZWMDv87EAvGbHBOSRG/ mZDoIQ0WV+t0cMwo+sgSx60uVNLGazKWoublyxTHWiaEPBgECHTe2IlTsmGt6NRrT3Z List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On March 10, 2025 3:27:02 PM GMT-04:00, Francisco Olarte wrote: >On Mon, 10 Mar 2025 at 20:18, H wrote: >> 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 > >Random? Then they CAN collide=2E ;-> > >Do the IDs need to be random or are they just the default value? > >I've encountered a similar problem with sequences and have bypassed it >by using explicit values into the test data, i=2Ee=2Em, inserting an >invoice with id 1000 followed by its lines with IDs 100010, 100011, >=2E=2E=2E=2E and then setting start_values for the sequences at 99999999= =2E This >helped me a lot in a debugging=2E You could do the same depending on >what domain your random ids are on=2E > >Francisco Olarte=2E K am using UUIDs which the application will use as well=2E