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 1p5OuR-0003Pc-3W for pgsql-bugs@arkaria.postgresql.org; Wed, 14 Dec 2022 10:22:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p5OuQ-0004kL-21 for pgsql-bugs@arkaria.postgresql.org; Wed, 14 Dec 2022 10:22: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 1p5NkE-0004d0-VN for pgsql-bugs@lists.postgresql.org; Wed, 14 Dec 2022 09:08:07 +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 1p5NkC-0002jK-Dl for pgsql-bugs@lists.postgresql.org; Wed, 14 Dec 2022 09:08:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=dlKzxzHtHweItx+LgLu4/tKb/xQe4mJ79gwKzz5PrZk=; b=sjiXBzWO85j+Brp+ohradfwFMq 0QFkg8r02gOD57OS4btuWP6clV3fQcA8mV65ABiq/x//hUVKYbzDSNa0K7Jms18LQB9pOjJFLmfRB i33n/g7sUo1scDCOrhq0hoUX+L5DxyNU5DJnLZMJbJnAZz7kq9YafWNKgyfAfD+my8dwlScFekvPG 2w8c5fYP81/QmhvmzUfiG2Nf0ZlKgQswLv0YXyunNS9fK11jdvyVPzKHN0870DlVMqjf5PXKKRY+9 8uT+lFykBRGw84WCEAp0F0BP7jJzZm/xJ6Sn+74CIrsRBCjQgynxvCYQFqVwSIhz6bTRQzAD2E2xF V0m3V9kQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p5NkB-0006Mr-Hb for pgsql-bugs@lists.postgresql.org; Wed, 14 Dec 2022 09:08:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1p5NkA-00DtT9-0K for pgsql-bugs@lists.postgresql.org; Wed, 14 Dec 2022 09:08:02 +0000 Content-Type: multipart/mixed; boundary="===============6641051687759148742==" MIME-Version: 1.0 Subject: BUG #17720: pg_dump creates a dump with primary key that cannot be restored, when specifying 'using index ...' To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: zedaardv@drizzle.com Reply-To: zedaardv@drizzle.com, pgsql-bugs@lists.postgresql.org Date: Wed, 14 Dec 2022 09:07:45 +0000 Message-ID: <17720-dab8ee0fa85d316d@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6641051687759148742== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzcyMApMb2dnZWQgYnk6ICAgICAgICAgIHJlaW5lciBwZXRlcmtlCkVt YWlsIGFkZHJlc3M6ICAgICAgemVkYWFyZHZAZHJpenpsZS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9u OiAxNS4xCk9wZXJhdGluZyBzeXN0ZW06ICAgb3BlblNVU0UgTGVhcCAxNS40CkRlc2NyaXB0aW9u OiAgICAgICAgCgpJIGhhdmUgYSB0YWJsZQ0KY3JlYXRlIHRhYmxlIGhhbXN0ZXIodW5kZXIgaW50 ZWdlciwgb3ZlciB0ZXh0KTsNCkkgY3JlYXRlIGEgdW5pcXVlIGluZGV4IG9uIHRoZSB1bmRlciBj b2x1bW4gd2l0aCBudWxscyBub3QgZGlzdGluY3QNCmNyZWF0ZSB1bmlxdWUgaW5kZXggdXFfbm90 X2Rpc3RpbmN0IG9uIGhhbXN0ZXIgKHVuZGVyKSBudWxscyBub3QgZGlzdGluY3Q7DQppIG5vdyBj cmVhdGUgYSBwcmltYXJ5IGtleSB1c2luZyB0aGUgdW5pcXVlIGluZGV4DQoNCmFsdGVyIHRhYmxl IGhhbXN0ZXIgYWRkIGNvbnN0cmFpbnQgcGtfaGFtc3RlciBwcmltYXJ5IGtleSB1c2luZyBpbmRl eAp1cV9ub3RfZGlzdGluY3Q7DQpOT1RJQ0U6ICBBTFRFUiBUQUJMRSAvIEFERCBDT05TVFJBSU5U IFVTSU5HIElOREVYIHdpbGwgcmVuYW1lIGluZGV4CiJ1cV9ub3RfZGlzdGluY3QiIHRvICJwa19o YW1zdGVyIg0KdGFibGUgbG9va3MgZ29vZA0KXGQgaGFtc3RlciANCiAgICAgICAgICAgICAgIFRh YmxlICJtb29uLmhhbXN0ZXIiDQogQ29sdW1uIHwgIFR5cGUgICB8IENvbGxhdGlvbiB8IE51bGxh YmxlIHwgRGVmYXVsdCANCi0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0t Ky0tLS0tLS0tLQ0KIHVuZGVyICB8IGludGVnZXIgfCAgICAgICAgICAgfCBub3QgbnVsbCB8IA0K IG92ZXIgICB8IHRleHQgICAgfCAgICAgICAgICAgfCAgICAgICAgICB8IA0KSW5kZXhlczoNCiAg ICAicGtfaGFtc3RlciIgUFJJTUFSWSBLRVksIGJ0cmVlICh1bmRlcikgTlVMTFMgTk9UIERJU1RJ TkNUDQoNCkRvIGEgcGdfZHVtcCBvZiB0aGUgZGF0YWJhc2UuDQp0aGUgZHVtcCBjcmVhdGVzIHRo ZSBjb2RlIGZvciBhIHByaW1hcnkga2V5IHRoYXQgY2Fubm90IGJlIHJlc3RvcmVkDQpwZ19kdW1w IC1wIDU2MzIgLU9mIHRyYW5xdWlsaXR5LnNxbCAgLWQgdHJhbnF1aWxpdHkNCm9uIHJlc3RvcmUs IEkgZ2V0IHRoZSBmb2xsb3dpbmcgZXJyb3INCnBzcWw6dHJhbnF1aWxpdHkuc3FsOjkwOiBFUlJP UjogIHN5bnRheCBlcnJvciBhdCBvciBuZWFyICJOVUxMUyINCkxJTkUgMjogICAgIEFERCBDT05T VFJBSU5UIHBrX2hhbXN0ZXIgUFJJTUFSWSBLRVkgTlVMTFMgTk9UIERJU1RJTkNULi4uDQppbiB0 aGUgZHVtcCBpdHNlbGYgdGhlIGNyZWF0ZSBjb25zdHJhaW50IGNvbW1hbmQgaXMNCkFMVEVSIFRB QkxFIE9OTFkgbW9vbi5oYW1zdGVyDQogICAgIEFERCBDT05TVFJBSU5UIHBrX2hhbXN0ZXIgUFJJ TUFSWSBLRVkgTlVMTFMgTk9UIERJU1RJTkNUICh1bmRlcik7DQp3aGljaCBkb2VzIG5vdCB3b3Jr IHdpdGggdGhlIE5VTExTIE5PVCBESVNUSU5DVCAgc3RyaW5nCgo= --===============6641051687759148742==--