Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v8anM-003QFo-EX for pgsql-bugs@arkaria.postgresql.org; Tue, 14 Oct 2025 08:54:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1v8anK-00Brmw-0Z for pgsql-bugs@arkaria.postgresql.org; Tue, 14 Oct 2025 08:54:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v8aAg-00BWps-31 for pgsql-bugs@lists.postgresql.org; Tue, 14 Oct 2025 08:14:15 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v8aAW-001g2U-20 for pgsql-bugs@lists.postgresql.org; Tue, 14 Oct 2025 08:14:14 +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=VJGyPCzM7XQ90CytRZ/Csl4XjBJHdGhe7VlVF8/wiEE=; b=uWNdEGHhP5snGiO1tgcSXHZ1bq QX057Z+S+OHTp0dCpGHm/1130ulG5Ynr1vfuMnCwQl0sc3/mYcvs3HVqET0925Iq4DwVr4/TYvQg+ 2qT6P7Gc8LW/zm23izGfigSUGu+AttUqBiH9MVrEpDLi8a7nOoX5g4q38MRgUDPFOH7LtBuPwOcug K0bwFMg3lHwVqgnvklHjxt6tcbJLXx+Bb7DyZ0zA3SdUgucdPIY435PBT8ba3eB2KpOM30sjOUPbX Cduz5omzq9FY9eHW7qPaGChgiC+54GCsm7vKcoo3CvIaGElT86P5qfSccqa4QSbdK1N3aumz66J9Q TwdwYMjw==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v8aAV-004cB5-SP for pgsql-bugs@lists.postgresql.org; Tue, 14 Oct 2025 08:14:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v8aAU-00H9y7-15 for pgsql-bugs@lists.postgresql.org; Tue, 14 Oct 2025 08:14:02 +0000 Content-Type: multipart/mixed; boundary="===============3227946716473119924==" MIME-Version: 1.0 Subject: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: andrewbille@gmail.com Reply-To: andrewbille@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 14 Oct 2025 08:13:52 +0000 Message-ID: <19086-871ff11017d03dc5@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 --===============3227946716473119924== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA4NgpMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJldyBCaWxsZQpFbWFp bCBhZGRyZXNzOiAgICAgIGFuZHJld2JpbGxlQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE4LjAKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gMTIKRGVzY3JpcHRpb246ICAgICAgICAK CkluIGNhc2Ugb2Ygc3lzdGVtIGluZGV4ZXMgY29ycnVwdGlvbiB0aGUgY29sbGVjdGluZyBvZiBp bmRleCBkZWZpbml0aW9ucyBjYW4KdGFrZSBhIHJlYWxseSBsb25nIHRpbWUuCgpTeW50aGV0aWMg ZXhhbXBsZToKCkRPICQkCkRFQ0xBUkUKICAgIGkgSU5URUdFUjsKICAgIGogSU5URUdFUjsKQkVH SU4KICAgIEZPUiBpIElOIDEuLjE1MDAwIExPT1AKICAgICAgICBFWEVDVVRFICdDUkVBVEUgVEFC TEUgdGFiJyAgaSAgJyBhcyBTRUxFQ1QgMSBhcyBmJzsKICAgICAgICBGT1IgaiBJTiAxLi41IExP T1AKICAgICAgICAgICAgRVhFQ1VURSAnQ1JFQVRFIGluZGV4IGlkeF90YWInICBpICAnXycgIGog ICAnIE9OIHRhYicgIGkgICcoZiknOwogICAgICAgIEVORCBMT09QOwogICAgRU5EIExPT1A7CkVO RDsKJCQ7CgpJZgppZ25vcmVfc3lzdGVtX2luZGV4ZXMgPSBvbgoKdGltZSBwZ19kdW1wIC0tZGF0 YS1vbmx5IHRlc3QgPiB0ZXN0LnNxbAoKcmVhbCAgICA2Mm00NCw1ODJzCnVzZXIgICAgMG0wLDU3 NnMKc3lzICAgICAwbTAsMjU5cwoKb2Ygd2hpY2gKTE9HOiAgZHVyYXRpb246IDM0NzQ0MjMuNjgz IG1zICBzdGF0ZW1lbnQ6IFNFTEVDVCB0LnRhYmxlb2lkLCB0Lm9pZCwKaS5pbmRyZWxpZCwgdC5y ZWxuYW1lIEFTIGluZGV4bmFtZSwgdC5yZWxwYWdlcywgdC5yZWx0dXBsZXMsCnQucmVsYWxsdmlz aWJsZSwgMCBBUyByZWxhbGxmcm96ZW4sIHBnX2NhdGFsb2cucGdfZ2V0X2luZGV4ZGVmKGkuaW5k ZXhyZWxpZCkKQVMgaW5kZXhkZWYsIGkuaW5ka2V5LCBpLmluZGlzY2x1c3RlcmVkLCBjLmNvbnR5 cGUsIGMuY29ubmFtZSwKYy5jb25kZWZlcnJhYmxlLCBjLmNvbmRlZmVycmVkLCBjLnRhYmxlb2lk IEFTIGNvbnRhYmxlb2lkLCBjLm9pZCBBUyBjb25vaWQsCnBnX2NhdGFsb2cucGdfZ2V0X2NvbnN0 cmFpbnRkZWYoYy5vaWQsIGZhbHNlKSBBUyBjb25kZWYsIENBU0UgV0hFTgppLmluZGV4cHJzIElT IE5PVCBOVUxMIFRIRU4gKFNFTEVDVCBwZ19jYXRhbG9nLmFycmF5X2FnZyhhdHRuYW1lIE9SREVS IEJZCmF0dG51bSkgIEZST00gcGdfY2F0YWxvZy5wZ19hdHRyaWJ1dGUgICBXSEVSRSBhdHRyZWxp ZCA9IGkuaW5kZXhyZWxpZCkgRUxTRQpOVUxMIEVORCBBUyBpbmRhdHRuYW1lcywgKFNFTEVDVCBz cGNuYW1lIEZST00gcGdfY2F0YWxvZy5wZ190YWJsZXNwYWNlIHMKV0hFUkUgcy5vaWQgPSB0LnJl bHRhYmxlc3BhY2UpIEFTIHRhYmxlc3BhY2UsIHQucmVsb3B0aW9ucyBBUyBpbmRyZWxvcHRpb25z LAppLmluZGlzcmVwbGlkZW50LCBpbmguaW5ocGFyZW50IEFTIHBhcmVudGlkeCwgaS5pbmRua2V5 YXR0cyBBUyBpbmRua2V5YXR0cywKaS5pbmRuYXR0cyBBUyBpbmRuYXR0cywgKFNFTEVDVCBwZ19j YXRhbG9nLmFycmF5X2FnZyhhdHRudW0gT1JERVIgQlkgYXR0bnVtKQpGUk9NIHBnX2NhdGFsb2cu cGdfYXR0cmlidXRlICAgV0hFUkUgYXR0cmVsaWQgPSBpLmluZGV4cmVsaWQgQU5ECmF0dHN0YXR0 YXJnZXQgPj0gMCkgQVMgaW5kc3RhdGNvbHMsIChTRUxFQ1QKcGdfY2F0YWxvZy5hcnJheV9hZ2co YXR0c3RhdHRhcmdldCBPUkRFUiBCWSBhdHRudW0pICAgRlJPTQpwZ19jYXRhbG9nLnBnX2F0dHJp YnV0ZSAgIFdIRVJFIGF0dHJlbGlkID0gaS5pbmRleHJlbGlkIEFORAphdHRzdGF0dGFyZ2V0ID49 IDApIEFTIGluZHN0YXR2YWxzLCBpLmluZG51bGxzbm90ZGlzdGluY3QsIE5VTEwgQVMgY29ucGVy aW9kCkZST00KdW5uZXN0KCd7MTYzODUsMTYzOTMsMTY0MDEsMTY0MDksMTY0MTcsMTY0MjUsMTY0 MzMsMTY0NDEsMTY0NDksMTY0NTcsMTY0NjUsMTY0NzMsMTY0ODEsMTY0ODksMTY0OTcsMTY1MDUs MTY1MTMsMTY1MjEsMTY1MjksMTY1MzcsMTY1NDUsMTY1NTMsMTY1NjEsMTY1NjksMTY1NzcsMTY1 ODUsMTY1OTMsMTY2MDEsMTY2MDksMTY2MTcsMTY2MjUsMTY2MzMsMTY2NDEsMTY2NDksMTY2NTcs MTY2NjUsMTY2NzMsMTY2ODEsMTY2ODksMTY2OTcsMTY3MDUsMTY3MTMsMTY3MjEsMTY3MjksMTY3 MzcsMTY3NDUsMTY3NTMsMTY3NjEsMTY3NjksMTY3NzcsMTY3ODUsMTY3OTMsMTY4MDEsMTY4MDks MTY4MTcsMTY4MjUsMTY4MzMsMTY4NDEsMTY4NDksMTY4NTcsMTY4NjUsMTY4NzMsMTY4ODEsMTY4 ODksMTY4OTcsMTY5MDUsMTY5MTMsMTY5MjEsMTY5MjksMTY5MzcsMTY5NDUsMTY5NTMsMTY5NjEs MTY5NjksMTY5NzcsMTY5ODUsMTY5OTMsMTcwMDEsMTcwMDksMTcwMTcsMTcwMjUsMTcwMzMsMTcw NDEsMTcwNDksMTcwNTcsMTcwNjUsMTcwNzMsMTcwODEsMTcwODksMTcwOTcsMTcxMDUsMTcxMTMs MTcxMjEsMTcxMjksMTcxMzcsMTcxNDUsMTcxNTMsMTcxNjEsMTcxNjksMTcxNzcsMTcxODUsMTcx OTMsMTcyMDEsMTcyMDksMTcyMTcKLi4uIDM2MzYxLDEzNjM2OSwxMzYzNzd9Jzo6cGdfY2F0YWxv Zy5vaWRbXSkgQVMgc3JjKHRibG9pZCkKICAgICAgICBKT0lOIHBnX2NhdGFsb2cucGdfaW5kZXgg aSBPTiAoc3JjLnRibG9pZCA9IGkuaW5kcmVsaWQpIEpPSU4KcGdfY2F0YWxvZy5wZ19jbGFzcyB0 IE9OICh0Lm9pZCA9IGkuaW5kZXhyZWxpZCkgSk9JTiBwZ19jYXRhbG9nLnBnX2NsYXNzIHQyCk9O ICh0Mi5vaWQgPSBpLmluZHJlbGlkKSBMRUZUIEpPSU4gcGdfY2F0YWxvZy5wZ19jb25zdHJhaW50 IGMgT04gKGkuaW5kcmVsaWQKPSBjLmNvbnJlbGlkIEFORCBpLmluZGV4cmVsaWQgPSBjLmNvbmlu ZGlkIEFORCBjLmNvbnR5cGUgSU4gKCdwJywndScsJ3gnKSkKTEVGVCBKT0lOIHBnX2NhdGFsb2cu cGdfaW5oZXJpdHMgaW5oIE9OIChpbmguaW5ocmVsaWQgPSBpbmRleHJlbGlkKSBXSEVSRQooaS5p bmRpc3ZhbGlkIE9SIHQyLnJlbGtpbmQgPSAncCcpIEFORCBpLmluZGlzcmVhZHkgT1JERVIgQlkg aS5pbmRyZWxpZCwKaW5kZXhuYW1lCgpXaXRoIGEgc2ltcGxlIHBhdGNoIChwYXNzZXMgdGVzdHMp CgpkaWZmIC0tZ2l0IGEvc3JjL2Jpbi9wZ19kdW1wL2NvbW1vbi5jIGIvc3JjL2Jpbi9wZ19kdW1w L2NvbW1vbi5jCmluZGV4IGExOTc2ZmFlNjA3Li40NzFlNjJkYTczNSAxMDA2NDQKLS0tIGEvc3Jj L2Jpbi9wZ19kdW1wL2NvbW1vbi5jCisrKyBiL3NyYy9iaW4vcGdfZHVtcC9jb21tb24uYwpAQCAt OTUsNyArOTUsNyBAQCBzdGF0aWMgSW5keEluZm8gKmZpbmRJbmRleEJ5T2lkKE9pZCBvaWQpOwog ICogICAgICAgQ29sbGVjdCBpbmZvcm1hdGlvbiBhYm91dCBhbGwgcG90ZW50aWFsbHkgZHVtcGFi bGUgb2JqZWN0cwogICovCiBUYWJsZUluZm8gKgotZ2V0U2NoZW1hRGF0YShBcmNoaXZlICpmb3V0 LCBpbnQgKm51bVRhYmxlc1B0cikKK2dldFNjaGVtYURhdGEoQXJjaGl2ZSAqZm91dCwgaW50ICpu dW1UYWJsZXNQdHIsIGJvb2wgZGF0YU9ubHkpCiB7CiAgICAgICAgVGFibGVJbmZvICAqdGJsaW5m bzsKICAgICAgICBFeHRlbnNpb25JbmZvICpleHRpbmZvOwpAQCAtMjExLDExICsyMTEsMTQgQEAg Z2V0U2NoZW1hRGF0YShBcmNoaXZlICpmb3V0LCBpbnQgKm51bVRhYmxlc1B0cikKICAgICAgICBw Z19sb2dfaW5mbygicmVhZGluZyBwYXJ0aXRpb25pbmcgZGF0YSIpOwogICAgICAgIGdldFBhcnRp dGlvbmluZ0luZm8oZm91dCk7CgotICAgICAgIHBnX2xvZ19pbmZvKCJyZWFkaW5nIGluZGV4ZXMi KTsKLSAgICAgICBnZXRJbmRleGVzKGZvdXQsIHRibGluZm8sIG51bVRhYmxlcyk7CisgICAgICAg aWYgKCFkYXRhT25seSkKKyAgICAgICB7CisgICAgICAgICAgICAgICBwZ19sb2dfaW5mbygicmVh ZGluZyBpbmRleGVzIik7CisgICAgICAgICAgICAgICBnZXRJbmRleGVzKGZvdXQsIHRibGluZm8s IG51bVRhYmxlcyk7CgotICAgICAgIHBnX2xvZ19pbmZvKCJmbGFnZ2luZyBpbmRleGVzIGluIHBh cnRpdGlvbmVkIHRhYmxlcyIpOwotICAgICAgIGZsYWdJbmhJbmRleGVzKGZvdXQsIHRibGluZm8s IG51bVRhYmxlcyk7CisgICAgICAgICAgICAgICBwZ19sb2dfaW5mbygiZmxhZ2dpbmcgaW5kZXhl cyBpbiBwYXJ0aXRpb25lZCB0YWJsZXMiKTsKKyAgICAgICAgICAgICAgIGZsYWdJbmhJbmRleGVz KGZvdXQsIHRibGluZm8sIG51bVRhYmxlcyk7CisgICAgICAgfQoKICAgICAgICBwZ19sb2dfaW5m bygicmVhZGluZyBleHRlbmRlZCBzdGF0aXN0aWNzIik7CiAgICAgICAgZ2V0RXh0ZW5kZWRTdGF0 aXN0aWNzKGZvdXQpOwpkaWZmIC0tZ2l0IGEvc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAuYyBiL3Ny Yy9iaW4vcGdfZHVtcC9wZ19kdW1wLmMKaW5kZXggNjQxYmVjZTEyYzcuLmVmOGJkNzg2MzcxIDEw MDY0NAotLS0gYS9zcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5jCisrKyBiL3NyYy9iaW4vcGdfZHVt cC9wZ19kdW1wLmMKQEAgLTEwOTAsNyArMTA5MCw3IEBAIG1haW4oaW50IGFyZ2MsIGNoYXIgKiph cmd2KQogICAgICAgICAqIE5vdyBzY2FuIHRoZSBkYXRhYmFzZSBhbmQgY3JlYXRlIER1bXBhYmxl T2JqZWN0IHN0cnVjdHMgZm9yIGFsbAp0aGUKICAgICAgICAgKiBvYmplY3RzIHdlIGludGVuZCB0 byBkdW1wLgogICAgICAgICAqLwotICAgICAgIHRibGluZm8gPSBnZXRTY2hlbWFEYXRhKGZvdXQs ICZudW1UYWJsZXMpOworICAgICAgIHRibGluZm8gPSBnZXRTY2hlbWFEYXRhKGZvdXQsICZudW1U YWJsZXMsIGRhdGFfb25seSk7CgogICAgICAgIGlmIChkb3B0LmR1bXBEYXRhKQogICAgICAgIHsK ZGlmZiAtLWdpdCBhL3NyYy9iaW4vcGdfZHVtcC9wZ19kdW1wLmggYi9zcmMvYmluL3BnX2R1bXAv cGdfZHVtcC5oCmluZGV4IGZhNmQxYTUxMGY3Li44M2UwOTc0MDRhMyAxMDA2NDQKLS0tIGEvc3Jj L2Jpbi9wZ19kdW1wL3BnX2R1bXAuaAorKysgYi9zcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5oCkBA IC03NTAsNyArNzUwLDcgQEAgdHlwZWRlZiBzdHJ1Y3QgX1N1YlJlbEluZm8KICAqICAgICBjb21t b24gdXRpbGl0eSBmdW5jdGlvbnMKICAqLwoKLWV4dGVybiBUYWJsZUluZm8gKmdldFNjaGVtYURh dGEoQXJjaGl2ZSAqZm91dCwgaW50ICpudW1UYWJsZXNQdHIpOworZXh0ZXJuIFRhYmxlSW5mbyAq Z2V0U2NoZW1hRGF0YShBcmNoaXZlICpmb3V0LCBpbnQgKm51bVRhYmxlc1B0ciwgYm9vbApkYXRh T25seSk7CgogZXh0ZXJuIHZvaWQgQXNzaWduRHVtcElkKER1bXBhYmxlT2JqZWN0ICpkb2JqKTsK IGV4dGVybiB2b2lkIHJlY29yZEFkZGl0aW9uYWxDYXRhbG9nSUQoQ2F0YWxvZ0lkIGNhdElkLCBE dW1wYWJsZU9iamVjdAoqZG9iaik7CgoKd2UgaGF2ZToKCnRpbWUgcGdfZHVtcCAtLWRhdGEtb25s eSB0ZXN0ID4gdGVzdC5zcWwKCnJlYWwgICAgN200NSw1MzNzCnVzZXIgICAgMG0wLDcyNnMKc3lz ICAgICAwbTAsNjM0cwoKSW4gdGhlIHJlYWwgY2FzZSBvZiBzeXN0ZW0gaW5kZXhlcyBjb3JydXB0 aW9uIC4uLiBkdW1wIGNhbiB0YWtlIGVub3VybW91cwphbW91bnQgb2YgdGltZS4KCg== --===============3227946716473119924==--