Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hslbd-0001om-Rw for pgsql-bugs@arkaria.postgresql.org; Wed, 31 Jul 2019 10:13:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hslbc-0007i3-N1 for pgsql-bugs@arkaria.postgresql.org; Wed, 31 Jul 2019 10:13:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hslbc-0007h9-ED for pgsql-bugs@lists.postgresql.org; Wed, 31 Jul 2019 10:13:12 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hslbU-0008IF-SL for pgsql-bugs@lists.postgresql.org; Wed, 31 Jul 2019 10:13:11 +0000 Content-Type: multipart/mixed; boundary="===============6816086735464439067==" MIME-Version: 1.0 Subject: BUG #15934: pg_dump output in wrong order if custom operator class is used as subtype_opclass in a range type To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tom@intevation.de Reply-To: tom@intevation.de, pgsql-bugs@lists.postgresql.org Date: Wed, 31 Jul 2019 10:12:25 +0000 Message-ID: <15934-58b8c8ab7a09ea15@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6816086735464439067== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTkzNApMb2dnZWQgYnk6ICAgICAgICAgIFRvbSBHb3R0ZnJpZWQKRW1h aWwgYWRkcmVzczogICAgICB0b21AaW50ZXZhdGlvbi5kZQpQb3N0Z3JlU1FMIHZlcnNpb246IDEx LjQKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCAoVWJ1bnR1IDE4LjA0KQpEZXNjcmlwdGlvbjog ICAgICAgIAoKRGVhciBQb3N0Z3JlU1FMIGRldmVsb3BlcnMsDQoNCmNvbnNpZGVyIHRoZSBmb2xs b3dpbmcgdG8gcmVwcm9kdWNlICh0byBrZWVwIHRoZSBleGFtcGxlIHNob3J0LCB0aGUgb3BlcmF0 b3IKY2xhc3MgaXMgcmVkdWNlZCB0byB0aGUgbWluaW11bSBuZWVkZWQgdG8gcmVwcm9kdWNlIHRo ZSBwcm9ibGVtKToNCg0KY3JlYXRlZGIgdGVzdA0KcHNxbCAtZCB0ZXN0IC1jICcNCkNSRUFURSBP UEVSQVRPUiB+fiAoDQogICAgRlVOQ1RJT04gPSBpbnQ0ZXEsDQogICAgTEVGVEFSRyA9IGludCwN CiAgICBSSUdIVEFSRyA9IGludA0KKTsNCkNSRUFURSBPUEVSQVRPUiBDTEFTUyB0ZXN0Y2xhc3Mg Rk9SIFRZUEUgaW50IFVTSU5HIGJ0cmVlIEFTDQogICAgT1BFUkFUT1IgMyB+fjsNCkNSRUFURSBU WVBFIHRlc3RyYW5nZSBBUyBSQU5HRSAoDQogICAgc3VidHlwZSA9IGludCwNCiAgICBzdWJ0eXBl X29wY2xhc3MgPSB0ZXN0Y2xhc3MNCik7Jw0KcGdfZHVtcCAtT2NDIHRlc3QgfCBwc3FsIC12IE9O X0VSUk9SX1NUT1A9DQoNClRoZSBvdXRwdXQgaXMgYXMgZm9sbG93czoNClsuLi5dDQpDUkVBVEUg T1BFUkFUT1IgRkFNSUxZDQpFUlJPUjogIG9wZXJhdG9yIGRvZXMgbm90IGV4aXN0OiBpbnRlZ2Vy IHB1YmxpYy5+fiBpbnRlZ2VyDQoNCkRyb3BwaW5nIGFuZCByZWNyZWF0aW5nIHRoZSBkYXRhYmFz ZSBhcyBhYm92ZSBhbmQgbG9va2luZyBhdCB0aGUgb3V0cHV0IG9mCmBwZ19kdW1wICAgLU9jQyB0 ZXN0JyBzaG93cyB0aGF0IHRoZSBEREwgZm9yIGNyZWF0aW5nIHRoZSBvcGVyYXRvciB1c2VkIGlu CnRoZSBvcGVyYXRvciBjbGFzcyBjb21lcyBhdCB0aGUgZW5kIChhZnRlciB0aGUgRERMIGZvciB0 aGUgb3BlcmF0b3IKY2xhc3MpOg0KLS0gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0K LS0gUG9zdGdyZVNRTCBkYXRhYmFzZSBkdW1wDQotLSAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgDQpbLi4uXQ0KLS0gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICANCi0tIE5hbWU6IHRlc3RjbGFz czsgVHlwZTogT1BFUkFUT1IgRkFNSUxZOyBTY2hlbWE6IHB1YmxpYzsgT3duZXI6IC0gICAgICAg ICAKICAgDQotLQ0KDQpDUkVBVEUgT1BFUkFUT1IgRkFNSUxZIHB1YmxpYy50ZXN0Y2xhc3MgVVNJ TkcgYnRyZWU7DQoNCg0KLS0NCi0tIE5hbWU6IHRlc3RjbGFzczsgVHlwZTogT1BFUkFUT1IgQ0xB U1M7IFNjaGVtYTogcHVibGljOyBPd25lcjogLQ0KLS0NCg0KQ1JFQVRFIE9QRVJBVE9SIENMQVNT IHB1YmxpYy50ZXN0Y2xhc3MNCiAgICBGT1IgVFlQRSBpbnRlZ2VyIFVTSU5HIGJ0cmVlIEZBTUlM WSBwdWJsaWMudGVzdGNsYXNzIEFTDQogICAgT1BFUkFUT1IgMyBwdWJsaWMufn4oaW50ZWdlcixp bnRlZ2VyKTsNCg0KDQotLQ0KLS0gTmFtZTogdGVzdHJhbmdlOyBUeXBlOiBUWVBFOyBTY2hlbWE6 IHB1YmxpYzsgT3duZXI6IC0NCi0tDQoNCkNSRUFURSBUWVBFIHB1YmxpYy50ZXN0cmFuZ2UgQVMg UkFOR0UgKA0KICAgIHN1YnR5cGUgPSBpbnRlZ2VyLA0KICAgIHN1YnR5cGVfb3BjbGFzcyA9IHB1 YmxpYy50ZXN0Y2xhc3MNCik7DQoNCg0KLS0NCi0tIE5hbWU6IH5+OyBUeXBlOiBPUEVSQVRPUjsg U2NoZW1hOiBwdWJsaWM7IE93bmVyOiAtDQotLQ0KDQpDUkVBVEUgT1BFUkFUT1IgcHVibGljLn5+ ICgNCiAgICBGVU5DVElPTiA9IGludDRlcSwNCiAgICBMRUZUQVJHID0gaW50ZWdlciwNCiAgICBS SUdIVEFSRyA9IGludGVnZXINCik7DQoNCg0KLS0NCi0tIFBvc3RncmVTUUwgZGF0YWJhc2UgZHVt cCBjb21wbGV0ZSAgICAgICAgICAgICAgICAgICAgDQotLQ0KDQoNCkEgc2ltaWxhciBlcnJvciBj YW4gYmUgcHJvZHVjZWQgdXNpbmcgYSBjdXN0b20tZm9ybWF0IGFyY2hpdmUgZmlsZToNCmNyZWF0 ZWRiIHRlc3RfbmV3DQpwZ19kdW1wIC1GYyB0ZXN0IHwgcGdfcmVzdG9yZSAtZWQgdGVzdF9uZXcN CnBnX3Jlc3RvcmU6IFthcmNoaXZlciAoZGIpXSBFcnJvciB3aGlsZSBQUk9DRVNTSU5HIFRPQzoN CnBnX3Jlc3RvcmU6IFthcmNoaXZlciAoZGIpXSBFcnJvciBmcm9tIFRPQyBlbnRyeSAxNTIyOyAy NjE2IDc3Nzk1IE9QRVJBVE9SCkNMQVNTIHRlc3RjbGFzcyBwb3N0Z3Jlcw0KcGdfcmVzdG9yZTog W2FyY2hpdmVyIChkYildIGNvdWxkIG5vdCBleGVjdXRlIHF1ZXJ5OiBFUlJPUjogIG9wZXJhdG9y IGRvZXMKbm90IGV4aXN0OiBpbnRlZ2VyIHB1YmxpYy5+fiBpbnRlZ2VyDQogICAgQ29tbWFuZCB3 YXM6IENSRUFURSBPUEVSQVRPUiBDTEFTUyBwdWJsaWMudGVzdGNsYXNzDQogICAgRk9SIFRZUEUg aW50ZWdlciBVU0lORyBidHJlZSBGQU1JTFkgcHVibGljLnRlc3RjbGFzcyBBUw0KICAgIE9QRVJB VE9SIDMgcHVibGljLn5+KGludGVnZXIsaW50ZWdlcik7DQoNCg0KRHJvcHBpbmcgYW5kIHJlY3Jl YXRpbmcgdGhlIGRhdGFiYXNlIGFzIGFib3ZlIGFnYWluIGJ1dCB3aXRob3V0IHRoZQpzdWJ0eXBl X29wY2xhc3MgaW4gdGhlIHR5cGUgZGVmaW5pdGlvbiBhbmQgcnVubmluZyBgcGdfZHVtcCAtT2ND IHRlc3QgfCBwc3FsCi12IE9OX0VSUk9SX1NUT1A9JyBnaXZlcyB0aGUgZm9sbG93aW5nIG91dHB1 dCB3aXRob3V0IGFueSBlcnJvcjoNClsuLi5dDQpDUkVBVEUgVFlQRQ0KQ1JFQVRFIE9QRVJBVE9S DQpDUkVBVEUgT1BFUkFUT1IgRkFNSUxZDQpDUkVBVEUgT1BFUkFUT1IgQ0xBU1MNCg0KSWYgdXNp bmcgdGhlIHN1YnR5cGVfb3BjbGFzcywgSSBleHBlY3RlZCBhIHNpbWlsYXIgb3V0cHV0IGJ1dCB3 aXRoIHRoZQonQ1JFQVRFIFRZUEUnIGF0IHRoZSBlbmQuDQoNClN5c3RlbSBpbmZvcm1hdGlvbjoN CnBzcWwgLXRjICdzZWxlY3QgdmVyc2lvbigpJw0KIFBvc3RncmVTUUwgMTEuNCAoVWJ1bnR1IDEx LjQtMS5wZ2RnMTguMDQrMSkgb24geDg2XzY0LXBjLWxpbnV4LWdudSwKY29tcGlsZWQgYnkNCiBn Y2MgKFVidW50dSA3LjQuMC0xdWJ1bnR1MX4xOC4wNC4xKSA3LjQuMCwgNjQtYml0DQoNClRoYW5r cyBhbmQgYmVzdCByZWdhcmRzLA0KVG9tCgo= --===============6816086735464439067==--