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 1msayf-0000NB-Ce for pgsql-committers@arkaria.postgresql.org; Thu, 02 Dec 2021 01:33:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1msayd-000437-Mm for pgsql-committers@arkaria.postgresql.org; Thu, 02 Dec 2021 01:33:35 +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 1msayd-00041B-Fp for pgsql-committers@lists.postgresql.org; Thu, 02 Dec 2021 01:33:35 +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-0007WC-G5 for pgsql-committers@lists.postgresql.org; Thu, 02 Dec 2021 01:33:34 +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-0000BJ-NE 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-0001fa-3j for pgsql-committers@lists.postgresql.org; Thu, 02 Dec 2021 01:33:31 +0000 Content-Type: multipart/mixed; boundary="===============0242472212040054908==" 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 --===============0242472212040054908== 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 OiAxMAoKQnJhbmNoCi0tLS0tLQpSRUxfMTNfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6 Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9mYWU1ZjA4ZTE3MTkzYThlMGM4Y2E5 NDFlMGJlZDRjNGQxMDVkZjE0CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmlu L3BnX3VwZ3JhZGUvdGVzdC5zaCAgICAgICAgICAgfCA0MSArKystLS0tLS0tLS0tLS0tLS0Kc3Jj L2Jpbi9wZ191cGdyYWRlL3VwZ3JhZGVfYWRhcHQuc3FsIHwgODAgKysrKysrKysrKysrKysrKysr KysrKysrKysrKysrKysrKysrCjIgZmlsZXMgY2hhbmdlZCwgODUgaW5zZXJ0aW9ucygrKSwgMzYg ZGVsZXRpb25zKC0pCgo= --===============0242472212040054908==--