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 1t1Lji-00FrSv-Aq for pgsql-bugs@arkaria.postgresql.org; Thu, 17 Oct 2024 08:19:58 +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 1t1Ljg-001FP5-GZ for pgsql-bugs@arkaria.postgresql.org; Thu, 17 Oct 2024 08:19:56 +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 1t1LWO-000xSi-Jg for pgsql-bugs@lists.postgresql.org; Thu, 17 Oct 2024 08:06:13 +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.94.2) (envelope-from ) id 1t1LWH-001KDC-9N for pgsql-bugs@lists.postgresql.org; Thu, 17 Oct 2024 08:06:11 +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=Hs+CzzBSe3QtHK/9zfBwvddMiqw6uBx2y1XiigvqhKI=; b=fDWiu2k5fzsPBUcDhuylT/SN7W 1uFaMIXV6oTpg/h/sNvWbSc9dM8wz/5mxssk9zSj3+zpHPMvGy6H+sNj79Dk8labqDhAqlDd5Rfnz K4vvqDioDnTTdW3mAuvxK10vkTmnpsqW2rwVNitWHCbWbL40F4jQ51QC3Xqi+zGd3Tr1aEsNzT0xi Wpo/ytdUhdiiANMZ1Awbtz2c/oSmkr1VOvrGVllFKKGdyOyMYLeinks2EoghMHtyp0ZmC6kaFVkph xxZmGua/0QpO34td9W1IxCe5Q1YsXMWovtQgop07t7pY0j4Ud1dayjs3o9RIDpRG8a2OR7UFRjX6k I6jUWzfg==; 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 1t1LWF-004AeF-92 for pgsql-bugs@lists.postgresql.org; Thu, 17 Oct 2024 08:06: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 1t1LWE-0078tV-1r for pgsql-bugs@lists.postgresql.org; Thu, 17 Oct 2024 08:06:02 +0000 Content-Type: multipart/mixed; boundary="===============2264788077257232720==" MIME-Version: 1.0 Subject: BUG #18660: information_schema.columns.ordinal_position has gaps when primary key columns are dropped To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: lukas.eder@gmail.com Reply-To: lukas.eder@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 17 Oct 2024 08:05:17 +0000 Message-ID: <18660-9ea9b58cce21a8bb@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 --===============2264788077257232720== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODY2MApMb2dnZWQgYnk6ICAgICAgICAgIEx1a2FzIEVkZXIKRW1haWwg YWRkcmVzczogICAgICBsdWthcy5lZGVyQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDE3 LjAKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCAoaW4gRG9ja2VyIG9uIFdpbmRvd3MpCkRlc2Ny aXB0aW9uOiAgICAgICAgCgpUaGUgcHJvYmxlbSBjYW4gYmUgaWxsdXN0cmF0ZWQgd2l0aCB0aGlz IHNpbXBsZSByZXByb2R1Y2VyIHNjcmlwdDoNCg0KQ1JFQVRFIFRBQkxFIHQgKA0KICBpMSBJTlQg Tk9UIE5VTEwsDQogIGkyIElOVCBOT1QgTlVMTCwNCiAgdCBURVhUIE5PVCBOVUxMDQopOw0KDQpB TFRFUiBUQUJMRSB0IEFERCBQUklNQVJZIEtFWSAoaTEsIGkyKTsNCkFMVEVSIFRBQkxFIHQgRFJP UCBDT0xVTU4gaTE7DQpBTFRFUiBUQUJMRSB0IEFERCBDT0xVTU4gaTMgSU5UIE5PVCBOVUxMOw0K DQpTRUxFQ1QgY29sdW1uX25hbWUsIG9yZGluYWxfcG9zaXRpb24NCkZST00gaW5mb3JtYXRpb25f c2NoZW1hLmNvbHVtbnMNCldIRVJFIHRhYmxlX25hbWUgPSAndCcNCk9SREVSIEJZIG9yZGluYWxf cG9zaXRpb247DQoNClRoZSBxdWVyeSByZXN1bHRzIGluOg0KDQp8Y29sdW1uX25hbWV8b3JkaW5h bF9wb3NpdGlvbnwNCnwtLS0tLS0tLS0tLXwtLS0tLS0tLS0tLS0tLS0tfA0KfGkyICAgICAgICAg fDIgICAgICAgICAgICAgICB8DQp8dCAgICAgICAgICB8MyAgICAgICAgICAgICAgIHwNCnxpMyAg ICAgICAgIHw0ICAgICAgICAgICAgICAgfA0KDQpUaGlzIGlzIGFnYWluc3QgdGhlIFNRTCBzdGFu ZGFyZCBzcGVjaWZpY2F0aW9uIG9mIHRoZQppbmZvcm1hdGlvbl9zY2hlbWEuY29sdW1ucy5vcmRp bmFsX3Bvc2l0aW9uIGNvbHVtbiwgd2hpY2ggaGFzIGEgY29uc3RyYWludAphcyBmb2xsb3dzOg0K DQpDT05TVFJBSU5UIENPTFVNTlNfT1JESU5BTF9QT1NJVElPTl9DT05USUdVT1VTX0NIRUNLIENI RUNLICgwID0gQUxMICgNCiAgU0VMRUNUIE1BWChPUkRJTkFMX1BPU0lUSU9OKSAtIENPVU5UKCop DQogIEZST00gQ09MVU1OUw0KICBHUk9VUCBCWQ0KICBUQUJMRV9DQVRBTE9HLCBUQUJMRV9TQ0hF TUEsIFRBQkxFX05BTUUgDQopKQ0KDQpJIHN1c3BlY3QgdGhpcyBpcyBiZWNhdXNlIHRoZSBpbnRl cm5hbCBwZ19hdHRyaWJ1dGUuYXR0bnVtIGxlYWtzIGludG8gdGhlCmluZm9ybWF0aW9uX3NjaGVt YS5jb2x1bW5zLm9yZGluYWxfcG9zaXRpb246DQoNClNFTEVDVCBhLmF0dG5hbWUsIGEuYXR0bnVt DQpGUk9NIHBnX2F0dHJpYnV0ZSBhDQpKT0lOIHBnX2NsYXNzIGMgT04gYS5hdHRyZWxpZCA9IGMu b2lkDQpXSEVSRSBjLnJlbG5hbWUgPSAndCcNCkFORCBhdHRudW0gPiAwDQpPUkRFUiBCWSBhdHRu dW07DQoNClByb2R1Y2VzIHRoaXM6DQoNCnxhdHRuYW1lICAgICAgICAgICAgICAgICAgICAgfGF0 dG51bXwNCnwtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tfC0tLS0tLXwNCnwuLi4uLi4uLnBn LmRyb3BwZWQuMS4uLi4uLi4ufDEgICAgIHwNCnxpMiAgICAgICAgICAgICAgICAgICAgICAgICAg fDIgICAgIHwNCnx0ICAgICAgICAgICAgICAgICAgICAgICAgICAgfDMgICAgIHwNCnxpMyAgICAg ICAgICAgICAgICAgICAgICAgICAgfDQgICAgIHwKCg== --===============2264788077257232720==--