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 1msb1g-0000Uk-6A for pgsql-committers@arkaria.postgresql.org; Thu, 02 Dec 2021 01:36:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1msb1e-0007os-RZ for pgsql-committers@arkaria.postgresql.org; Thu, 02 Dec 2021 01:36:42 +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 1msayf-0004Vu-SH for pgsql-committers@lists.postgresql.org; Thu, 02 Dec 2021 01:33:37 +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 1msaya-0007WF-Gj for pgsql-committers@lists.postgresql.org; Thu, 02 Dec 2021 01:33:36 +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 1msayZ-0000BI-NB for pgsql-committers@lists.postgresql.org; Thu, 02 Dec 2021 01:33:31 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1msayZ-0001fY-3L for pgsql-committers@lists.postgresql.org; Thu, 02 Dec 2021 01:33:31 +0000 Content-Type: multipart/mixed; boundary="===============8171075909224824375==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Move into separate file all the SQL queries used in pg_upgrade t X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 02 Dec 2021 01:33:31 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8171075909224824375== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 TW92ZSBpbnRvIHNlcGFyYXRlIGZpbGUgYWxsIHRoZSBTUUwgcXVlcmllcyB1c2VkIGluIHBnX3Vw Z3JhZGUgdGVzdHMKClRoZSBleGlzdGluZyBwZ191cGdyYWRlL3Rlc3Quc2ggYW5kIHRoZSBidWls ZGZhcm0gY29kZSBoYXZlIGJlZW4gaG9sZGluZwp0aGUgc2FtZSBzZXQgb2YgU1FMIHF1ZXJpZXMg d2hlbiBkb2luZyBjcm9zcy12ZXJzaW9uIHVwZ3JhZGUgdGVzdHMgdG8KYWRhcHQgdGhlIG9iamVj dHMgY3JlYXRlZCBieSB0aGUgcmVncmVzc2lvbiB0ZXN0cyBiZWZvcmUgdGhlIHVwZ3JhZGUKKG1v c3RseSwgaW5jb21wYXRpYmxlIG9yIG5vbi1leGlzdGluZyBvYmplY3RzIG5lZWQgdG8gYmUgZHJv cHBlZCBmcm9tCnRoZSBvcmlnaW4sIHBlcmhhcHMgcmUtY3JlYXRlZCkuCgpUaGlzIG1vdmVzIGFs bCB0aG9zZSBTUUwgcXVlcmllcyBpbnRvIGEgbmV3LCBzZXBhcmF0ZSwgZmlsZSB3aXRoIGEgc2V0 Cm9mIFxpZiBjbGF1c2VzIHRvIGhhbmRsZSB0aGUgdmVyc2lvbiBjaGVja3MgZGVwZW5kaW5nIG9u IHRoZSBvbGQgdmVyc2lvbgpvZiB0aGUgY2x1c3RlciB0by1iZS11cGdyYWRlZC4KClRoZSBsb25n LXRlcm0gcGxhbiBpcyB0byBtYWtlIHRoZSBidWlsZGZhcm0gY29kZSByZS11c2UgdGhpcyBuZXcg U1FMCmZpbGUsIHNvIGFzIGNvbW1pdHRlcnMgYXJlIGFibGUgdG8gZml4IGFueSBjb21wYXRpYmls aXR5IGlzc3VlcyBpbiB0aGUKdGVzdHMgb2YgcGdfdXBncmFkZSB3aXRoIGEgcmVmcmVzaCBvZiB0 aGUgY29yZSBjb2RlLCB3aXRob3V0IGhhdmluZyB0bwpwb2tlIGF0IHRoZSBidWlsZGZhcm0gY2xp ZW50LiAgTm90ZSB0aGF0IHRoaXMgaXMgb25seSBhYmxlIHRvIGhhbmRsZSB0aGUKbWFpbiByZWdy ZXNzaW9uIHRlc3Qgc3VpdGUsIGFuZCB0aGF0IG5vdGhpbmcgaXMgZG9uZSB5ZXQgZm9yIGNvbnRy aWIKbW9kdWxlcyB5ZXQgKHRoZXNlIGhhdmUgbW9yZSBpc3N1ZXMgbGlrZSB0aGVpciBkYXRhYmFz ZSBuYW1lcykuCgpBIGJhY2twYXRjaCBkb3duIHRvIDEwIGlzIGRvbmUsIGFkYXB0aW5nIHRoZSB2 ZXJzaW9uIGNoZWNrcyBhcyB0aGlzCnNjcmlwdCBuZWVkcyB0byBiZSBvbmx5IGJhY2t3YXJkLWNv bXBhdGlibGUsIHNvIGFzIGl0IGJlY29tZXMgcG9zc2libGUKdG8gY2xlYW4gdXAgYSBtYXhpbXVt IGFtb3VudCBvZiBjb2RlIHdpdGhpbiB0aGUgYnVpbGRmYXJtIGNsaWVudC4KCkF1dGhvcjogSnVz dGluIFByeXpieSwgTWljaGFlbCBQYXF1aWVyCkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVz L20vMjAyMDEyMDYxODAyNDguR0kyNDA1MkB0ZWxzYXNvZnQuY29tCkJhY2twYXRjaC10aHJvdWdo OiAxMAoKQnJhbmNoCi0tLS0tLQpSRUxfMTRfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6 Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9iNmRhYzk4YjA1NjE4YzIyYmYzNTdl NWZjZjIzYWQyNDE5MDEzNDM5CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmlu L3BnX3VwZ3JhZGUvdGVzdC5zaCAgICAgICAgICAgfCA1MiArKy0tLS0tLS0tLS0tLS0tLS0tLS0K c3JjL2Jpbi9wZ191cGdyYWRlL3VwZ3JhZGVfYWRhcHQuc3FsIHwgOTEgKysrKysrKysrKysrKysr KysrKysrKysrKysrKysrKysrKysrCjIgZmlsZXMgY2hhbmdlZCwgOTYgaW5zZXJ0aW9ucygrKSwg NDcgZGVsZXRpb25zKC0pCgo= --===============8171075909224824375==--