Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mrWUO-0002Zh-0a for pgsql-committers@arkaria.postgresql.org; Mon, 29 Nov 2021 02:33:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mrWUM-0002kc-2R for pgsql-committers@arkaria.postgresql.org; Mon, 29 Nov 2021 02:33:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mrWUL-0002kT-RX for pgsql-committers@lists.postgresql.org; Mon, 29 Nov 2021 02:33:53 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mrWUE-0006xW-RB for pgsql-committers@lists.postgresql.org; Mon, 29 Nov 2021 02:33:52 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mrWUE-00045C-7Q for pgsql-committers@lists.postgresql.org; Mon, 29 Nov 2021 02:33:46 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mrWUD-000235-Hq for pgsql-committers@lists.postgresql.org; Mon, 29 Nov 2021 02:33:45 +0000 Content-Type: multipart/mixed; boundary="===============1080292870634329615==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Replace random(), pg_erand48(), etc with a better PRNG API and a X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Nov 2021 02:33:45 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1080292870634329615== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVwbGFjZSByYW5kb20oKSwgcGdfZXJhbmQ0OCgpLCBldGMgd2l0aCBhIGJldHRlciBQUk5HIEFQ SSBhbmQgYWxnb3JpdGhtLgoKU3RhbmRhcmRpemUgb24geG9yb3NoaXJvMTI4KiogYXMgb3VyIGJh c2ljIFBSTkcgYWxnb3JpdGhtLCBlbGltaW5hdGluZwphIGJ1bmNoIG9mIHBsYXRmb3JtIGRlcGVu ZGVuY2llcyBhcyB3ZWxsIGFzIGZ1bmRhbWVudGFsbHktb2Jzb2xldGUgUFJORwpjb2RlLiAgSW4g YWRkaXRpb24sIHRoaXMgQVBJIHJlcGxhY2VtZW50IHdpbGwgZWFzZSByZXBsYWNpbmcgdGhlCmFs Z29yaXRobSBhZ2FpbiBpbiBmdXR1cmUsIHNob3VsZCB0aGF0IGJlY29tZSBuZWNlc3NhcnkuCgp4 b3Jvc2hpcm8xMjgqKiBpcyBhIGZldyBwZXJjZW50IHNsb3dlciB0aGFuIHRoZSBkcmFuZDQ4IGZh bWlseSwKYnV0IGl0IGNhbiBwcm9kdWNlIGZ1bGwtd2lkdGggNjQtYml0IHJhbmRvbSB2YWx1ZXMg bm90IG9ubHkgNDgtYml0LAphbmQgaXQgc2hvdWxkIGJlIG11Y2ggbW9yZSB0cnVzdHdvcnRoeS4g IEl0J3MgbGlrZWx5IHRvIGJlIG5vdGljZWFibHkKZmFzdGVyIHRoYW4gdGhlIHBsYXRmb3JtJ3Mg cmFuZG9tKCksIGRlcGVuZGluZyBvbiB3aGljaCBwbGF0Zm9ybSB5b3UKYXJlIHRoaW5raW5nIGFi b3V0OyBhbmQgd2UgY2FuIGhhdmUgbm9uLWdsb2JhbCBzdGF0ZSB2ZWN0b3JzIGVhc2lseSwKdW5s aWtlIHdpdGggcmFuZG9tKCkuICBJdCBpcyBub3QgY3J5cHRvZ3JhcGhpY2FsbHkgc3Ryb25nLCBi dXQgbmVpdGhlcgphcmUgdGhlIGZ1bmN0aW9ucyBpdCByZXBsYWNlcy4KCkZhYmllbiBDb2VsaG8s IHJldmlld2VkIGJ5IERlYW4gUmFzaGVlZCwgQWxla3NhbmRlciBBbGVrc2VldiwgYW5kIG15c2Vs ZgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9hbHBpbmUuREVCLjIuMjIuMzk0LjIx MDUyNDEyMTEyMzAuMTY1NDE4QHBzZXVkbwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzM4MDQ1Mzll NDhlNzk0NzgxYzYxNDVjN2Y5ODhmNWQ1MDc0MThmYTgKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCmNvbmZpZ3VyZSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IHwgIDI2IC0tLQpjb25maWd1cmUuYWMgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICB8ICAgMiAtCmNvbnRyaWIvYW1jaGVjay92ZXJpZnlfbmJ0cmVlLmMgICAgICAgICAgICAg ICAgICAgIHwgICA1ICstCmNvbnRyaWIvYXV0b19leHBsYWluL2F1dG9fZXhwbGFpbi5jICAgICAg ICAgICAgICAgIHwgICA0ICstCmNvbnRyaWIvZmlsZV9mZHcvZmlsZV9mZHcuYyAgICAgICAgICAg ICAgICAgICAgICAgIHwgICAyICstCmNvbnRyaWIvcG9zdGdyZXNfZmR3L3Bvc3RncmVzX2Zkdy5j ICAgICAgICAgICAgICAgIHwgICAyICstCmNvbnRyaWIvdGFibGVmdW5jL3RhYmxlZnVuYy5jICAg ICAgICAgICAgICAgICAgICAgIHwgICA1ICstCmNvbnRyaWIvdHNtX3N5c3RlbV9yb3dzL3RzbV9z eXN0ZW1fcm93cy5jICAgICAgICAgIHwgIDEyICstCmNvbnRyaWIvdHNtX3N5c3RlbV90aW1lL3Rz bV9zeXN0ZW1fdGltZS5jICAgICAgICAgIHwgIDEyICstCnNyYy9iYWNrZW5kL2FjY2Vzcy9naW4v Z2luZ2V0LmMgICAgICAgICAgICAgICAgICAgIHwgICAzICstCnNyYy9iYWNrZW5kL2FjY2Vzcy9n aXN0L2dpc3R1dGlsLmMgICAgICAgICAgICAgICAgIHwgICA1ICstCnNyYy9iYWNrZW5kL2FjY2Vz cy9uYnRyZWUvbmJ0aW5zZXJ0LmMgICAgICAgICAgICAgIHwgICAzICstCnNyYy9iYWNrZW5kL2Fj Y2Vzcy9zcGdpc3Qvc3BnZG9pbnNlcnQuYyAgICAgICAgICAgIHwgICA1ICstCnNyYy9iYWNrZW5k L2FjY2Vzcy90cmFuc2FtL3hhY3QuYyAgICAgICAgICAgICAgICAgIHwgICAzICstCnNyYy9iYWNr ZW5kL2NvbW1hbmRzL2FuYWx5emUuYyAgICAgICAgICAgICAgICAgICAgIHwgICA3ICstCnNyYy9i YWNrZW5kL2V4ZWN1dG9yL25vZGVTYW1wbGVzY2FuLmMgICAgICAgICAgICAgIHwgICAzICstCnNy Yy9iYWNrZW5kL2xpYi9ibG9vbWZpbHRlci5jICAgICAgICAgICAgICAgICAgICAgIHwgICAzICst CnNyYy9iYWNrZW5kL29wdGltaXplci9nZXFvL2dlcW9fcmFuZG9tLmMgICAgICAgICAgIHwgIDIz ICstCnNyYy9iYWNrZW5kL29wdGltaXplci9nZXFvL2dlcW9fc2VsZWN0aW9uLmMgICAgICAgIHwg IDE0ICstCnNyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvcG9zdG1hc3Rlci5jICAgICAgICAgICAgICAg IHwgIDIwICstCnNyYy9iYWNrZW5kL3N0b3JhZ2UvZmlsZS9mZC5jICAgICAgICAgICAgICAgICAg ICAgIHwgICA0ICstCnNyYy9iYWNrZW5kL3N0b3JhZ2UvaXBjL2RzbS5jICAgICAgICAgICAgICAg ICAgICAgIHwgICA5ICstCnNyYy9iYWNrZW5kL3N0b3JhZ2UvbG1nci9NYWtlZmlsZSAgICAgICAg ICAgICAgICAgIHwgICA1ICstCnNyYy9iYWNrZW5kL3N0b3JhZ2UvbG1nci9zX2xvY2suYyAgICAg ICAgICAgICAgICAgIHwgICA1ICstCnNyYy9iYWNrZW5kL3Rjb3AvcG9zdGdyZXMuYyAgICAgICAg ICAgICAgICAgICAgICAgIHwgICA3ICstCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9mbG9hdC5jICAg ICAgICAgICAgICAgICAgICAgIHwgIDIwICstCnNyYy9iYWNrZW5kL3V0aWxzL21pc2Mvc2FtcGxp bmcuYyAgICAgICAgICAgICAgICAgIHwgIDUyICsrKy0tCnNyYy9iaW4vaW5pdGRiL2luaXRkYi5j ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICA4ICstCnNyYy9iaW4vcGdfdGVzdF9mc3lu Yy9wZ190ZXN0X2ZzeW5jLmMgICAgICAgICAgICAgIHwgICA1ICstCnNyYy9iaW4vcGdiZW5jaC9w Z2JlbmNoLmMgICAgICAgICAgICAgICAgICAgICAgICAgIHwgMTIyICsrKystLS0tLS0Kc3JjL2Jp bi9wZ2JlbmNoL3QvMDAxX3BnYmVuY2hfd2l0aF9zZXJ2ZXIucGwgICAgICAgfCAgMjMgKy0Kc3Jj L2NvbW1vbi9NYWtlZmlsZSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDEgKwpz cmMvY29tbW9uL3BnX3BybmcuYyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8IDI0NyAr KysrKysrKysrKysrKysrKysrKysKc3JjL2luY2x1ZGUvY29tbW9uL3BnX3BybmcuaCAgICAgICAg ICAgICAgICAgICAgICAgfCAgNjAgKysrKysKc3JjL2luY2x1ZGUvb3B0aW1pemVyL2dlcW8uaCAg ICAgICAgICAgICAgICAgICAgICAgfCAgIDMgKy0Kc3JjL2luY2x1ZGUvb3B0aW1pemVyL2dlcW9f cmFuZG9tLmggICAgICAgICAgICAgICAgfCAgIDUgKy0Kc3JjL2luY2x1ZGUvcGdfY29uZmlnLmgu aW4gICAgICAgICAgICAgICAgICAgICAgICAgfCAgIDYgLQpzcmMvaW5jbHVkZS9wZ19jb25maWdf bWFudWFsLmggICAgICAgICAgICAgICAgICAgICB8ICAxMSAtCnNyYy9pbmNsdWRlL3BvcnQuaCAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgIDEzIC0tCnNyYy9pbmNsdWRlL3V0aWxz L3NhbXBsaW5nLmggICAgICAgICAgICAgICAgICAgICAgIHwgIDE1ICstCnNyYy9wb3J0L01ha2Vm aWxlICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgICAxIC0Kc3JjL3BvcnQvZXJh bmQ0OC5jICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgfCAxMzYgLS0tLS0tLS0tLS0t CnNyYy9wb3J0L3JhbmRvbS5jICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHwgIDI1 IC0tLQpzcmMvcG9ydC9zcmFuZG9tLmMgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8 ICAyNSAtLS0KLi4uL21vZHVsZXMvdGVzdF9ibG9vbWZpbHRlci90ZXN0X2Jsb29tZmlsdGVyLmMg ICAgfCAgIDQgKy0Kc3JjL3Rlc3QvbW9kdWxlcy90ZXN0X2ludGVnZXJzZXQvdGVzdF9pbnRlZ2Vy c2V0LmMgfCAgIDYgKy0Kc3JjL3Rlc3QvbW9kdWxlcy90ZXN0X3JidHJlZS90ZXN0X3JidHJlZS5j ICAgICAgICAgfCAgIDUgKy0Kc3JjL3Rvb2xzL21zdmMvTWt2Y2J1aWxkLnBtICAgICAgICAgICAg ICAgICAgICAgICAgfCAgMTIgKy0Kc3JjL3Rvb2xzL21zdmMvU29sdXRpb24ucG0gICAgICAgICAg ICAgICAgICAgICAgICAgfCAgIDIgLQpzcmMvdG9vbHMvdGVzdGludDEyOC5jICAgICAgICAgICAg ICAgICAgICAgICAgICAgICB8ICAyOSArLS0KNTAgZmlsZXMgY2hhbmdlZCwgNTQ0IGluc2VydGlv bnMoKyksIDQ4MSBkZWxldGlvbnMoLSkKCg== --===============1080292870634329615==--