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.96) (envelope-from ) id 1wVVYT-0020nT-07 for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Jun 2026 14:29:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wVVYR-00Ct9I-35 for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Jun 2026 14:29:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wVVYR-00Ct9A-0g for pgsql-hackers@lists.postgresql.org; Fri, 05 Jun 2026 14:29:47 +0000 Received: from smtpbg151.qq.com ([18.169.211.239]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wVVYF-00000001Qtb-11sN for pgsql-hackers@lists.postgresql.org; Fri, 05 Jun 2026 14:29:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=halodbtech.com; s=wqvr2403; t=1780669754; bh=9gQzQ/XjsIWqDzZQS2pOB/03UZ3ugdxn4rK1YAkeSrc=; h=From:To:Subject:Mime-Version:Date:Message-ID; b=Q6BYRhurg1jb9NsT4nCZ+2uCdzqRDGTYemqoe8Pm2H3bIm8Df49JUAhYQ0QjxYmq0 gqpJom9MciGhL38k/W4tgNGLoqt2uKS6u6GqrrbaZipZP2UKcG6ZQUzn/dwZCUuOPp igeSGVDuVss4YAS6oHHXKChpOXZja2ZccXf7BmRk= EX-QQ-RecipientCnt: 3 X-QQ-GoodBg: 2 X-QQ-SSF: 00400000000000F0 X-QQ-FEAT: D4aqtcRDiqSE8ZG9RUj9sSovWVo5u0ua16tXdykBVCI= X-QQ-BUSINESS-ORIGIN: 2 X-QQ-Originating-IP: laBoI9PSZBXnb+3DTI3JmXU9JM8SD8np1EA2n/h9XG0= X-Originating-IP: 112.10.2.143 X-QQ-STYLE: X-QQ-mid: lv3gz7b-4t1780669753t5ea87baa From: "=?ISO-8859-1?B?emVuZ21hbg==?=" To: "=?ISO-8859-1?B?cGdzcWwtaGFja2Vycw==?=" Cc: "=?ISO-8859-1?B?QXNodXRvc2ggQmFwYXQ=?=" , "=?ISO-8859-1?B?UGV0ZXIgRWlzZW50cmF1dA==?=" Subject: (SQL/PGQ) Clean up orphaned properties when dropping a label Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_6A22DD38_6F1F9FC0_262DDA3C" Content-Transfer-Encoding: 8Bit Date: Fri, 5 Jun 2026 22:29:12 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x X-BIZMAIL-ID: 17146543537492364017 X-Address-Ticket: version=;type=;ticket_id=;id_list=;display_name=;session_id=; X-QQ-SENDSIZE: 520 Received: from qq.com (unknown [127.0.0.1]) by smtp.qq.com (ESMTP) with SMTP id ; Fri, 05 Jun 2026 22:29:14 +0800 (CST) Feedback-ID: lv:halodbtech.com:qybglogicsvrsz:qybglogicsvrsz4b-0 X-QQ-XMAILINFO: NNCgUTg3ctKTexuFnO9Hs7ZOmp1IPNsh6z74C2640r17+yLiIsYKp2K4 Crs078pj0/M1bMqa+fFNCx4ZE/6UfrRvXGEDT5iQnoE72duQesexgS9ws+Mmk4qJh4sFq34 dIB7eVmnSmi58nYW14F7IU/mlQn2AKtgK3GlINkw7BxRgFFFyfBmiyqO81fy9M9GUJUTUlD dDwmvoLY92xxB1sudtMlt6NDl5MRzER5uJJkyvyK3qjH6MtOilxNdkj0A3fZpWxzkA323DF NklJqdr7gzkuJcWgB3dOurk+0FwP2b3VJZoMjhNaoMzGKuESMa03lOVT70d7fW4PvmzQUbV CZ7vP6b4s2tNv1KJ+/ZjmlflOs3RwOeHL1gIU6+wjsbfi6kgV/adCAKNqWxttG5+RnDK6lp TrQ8C3S88g0c+xDpPIYDfBjLpdcP8gZV3YhMocHufVRjYyZVVr4t2Aljie8jTAmj+ATtbVe Mu87sRA7SPWqFnu0bPlJmvC2wrQNHnGid2u/+ROwrGJGvZm1eXldwl+NpRhA4CwIveb8ifh NQ8in49RnqO/bxYPaLN3oIlIPvRAJywCpzrXMAwWG7VOb8afHA2L16t++q+ePixtTg73zkp uuGwKwmOHpgwXilYfDHiRlEnOxt58+ssnMoHZebFxlIY0LTtwHQLz3FP+JPnsgHe4xRNtGn re4gxuu5atOX6AbxHRheKymWmniE5+jRWVQdV05wRcCTUiAiLf98lT43QG1Kd1vku7r8VUT oc1ANEGXsQvwDvnEasiLyukDmw+ppwAqC7t7OrsRp/bzkn4+UgmdWsHlJwkPv6JcXyCvnXd omDqEBEDAittPLvMavpuRt3PClcIVAZgOJWOuJGRfWa7Aa0jtmSM1LFQHxvNfqayivBiaQ8 wH8JZqKC5F6SzSJUonUkErx0OsE+fTSxs7B1Kqn22Iyx9JyvcXpfmRCsP1dpXDvmo90OYwz 0rOtc+uodcU+Y4vVvqrjrgmCMgcr1IoSpvNVZQb0Yrvuhw+rBWe11hl3Mru3H57qKdHKoBF nSAQNvwYut6mQ6yveqfGnfpXdRnG7d7g7n5JP3yA== X-QQ-XMRINFO: Nq+8W0+stu50tPAe92KXseR0ZZmBTk3gLg== X-QQ-RECHKSPAM: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_NextPart_6A22DD38_6F1F9FC0_262DDA3C Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 SGkgYWxsLA0KDQpJIG5vdGljZWQgdGhhdCBBTFRFUiBQUk9QRVJUWSBHUkFQSCAuLi4gRFJP UCBMQUJFTCBkb2Vzbid0IGNsZWFuIHVwDQpvcnBoYW5lZCBwZ19wcm9wZ3JhcGhfcHJvcGVy dHkgZW50cmllcy4gVGhlIGNsZWFudXAgY29uZGl0aW9uIGluDQpSZW1vdmVSZWxhdGlvbnMo KSBvbmx5IGNoZWNrcyBmb3IgZHJvcF9wcm9wZXJ0aWVzLA0KZHJvcF92ZXJ0ZXhfdGFibGVz LCBhbmQgZHJvcF9lZGdlX3RhYmxlcywgYnV0IG5vdCBkcm9wX2xhYmVsLg0KDQpCZWZvcmUg Zml4Og0KDQpgYGBzcWwNCnBvc3RncmVzQHp4bS1WTXdhcmUtVmlydHVhbC1QbGF0Zm9ybTp+ L2NvZGUvcG9zdGdyZXMkIHBzcWwNCnBzcWwgKDE5YmV0YTEpDQpUeXBlICJoZWxwIiBmb3Ig aGVscC4NCg0KcG9zdGdyZXM9IyBDUkVBVEUgVEFCTEUgdjQgKGEgaW50IFBSSU1BUlkgS0VZ LCBiIGludCwgYyBpbnQpOw0KQ1JFQVRFIFRBQkxFDQpwb3N0Z3Jlcz0jIENSRUFURSBQUk9Q RVJUWSBHUkFQSCBnNQ0KICAgIFZFUlRFWCBUQUJMRVMgKA0KICAgICAgICB2NCBMQUJFTCBs MSBQUk9QRVJUSUVTIChhLCBiLCBjKQ0KICAgICAgICAgICBMQUJFTCBsMiBQUk9QRVJUSUVT IChhKQ0KICAgICk7DQpDUkVBVEUgUFJPUEVSVFkgR1JBUEgNCnBvc3RncmVzPSMgQUxURVIg UFJPUEVSVFkgR1JBUEggZzUgQUxURVIgVkVSVEVYIFRBQkxFIHY0IERST1AgTEFCRUwgbDE7 DQpBTFRFUiBQUk9QRVJUWSBHUkFQSA0KcG9zdGdyZXM9IyBTRUxFQ1QgcGdwbmFtZSBGUk9N IHBnX3Byb3BncmFwaF9wcm9wZXJ0eQ0KICAgIFdIRVJFIHBncHBnaWQgPSAnZzUnOjpyZWdj bGFzcyBPUkRFUiBCWSBwZ3BuYW1lOw0KIHBncG5hbWUNCi0tLS0tLS0tLQ0KIGENCiBiDQog Yw0KKDMgcm93cykNCmBgYA0KDQpBZnRlciBmaXg6DQpgYGBzcWwNCnBvc3RncmVzQHp4bS1W TXdhcmUtVmlydHVhbC1QbGF0Zm9ybTp+L2NvZGUvcG9zdGdyZXMkIHBzcWwNCnBzcWwgKDE5 YmV0YTEpDQpUeXBlICJoZWxwIiBmb3IgaGVscC4NCg0KcG9zdGdyZXM9IyBDUkVBVEUgVEFC TEUgdjQgKGEgaW50IFBSSU1BUlkgS0VZLCBiIGludCwgYyBpbnQpOw0KQ1JFQVRFIFRBQkxF DQpwb3N0Z3Jlcz0jIENSRUFURSBQUk9QRVJUWSBHUkFQSCBnNQ0KICAgIFZFUlRFWCBUQUJM RVMgKA0KICAgICAgICB2NCBMQUJFTCBsMSBQUk9QRVJUSUVTIChhLCBiLCBjKQ0KICAgICAg ICAgICBMQUJFTCBsMiBQUk9QRVJUSUVTIChhKQ0KICAgICk7DQpDUkVBVEUgUFJPUEVSVFkg R1JBUEgNCnBvc3RncmVzPSMgQUxURVIgUFJPUEVSVFkgR1JBUEggZzUgQUxURVIgVkVSVEVY IFRBQkxFIHY0IERST1AgTEFCRUwgbDE7DQpBTFRFUiBQUk9QRVJUWSBHUkFQSA0KcG9zdGdy ZXM9IyBTRUxFQ1QgcGdwbmFtZSBGUk9NIHBnX3Byb3BncmFwaF9wcm9wZXJ0eQ0KICAgIFdI RVJFIHBncHBnaWQgPSAnZzUnOjpyZWdjbGFzcyBPUkRFUiBCWSBwZ3BuYW1lOw0KIHBncG5h bWUNCi0tLS0tLS0tLQ0KIGENCigxIHJvdykNCmBgYA0KDQpgYGBzcWwNCkNSRUFURSBUQUJM RSB2NCAoYSBpbnQgUFJJTUFSWSBLRVksIGIgaW50LCBjIGludCk7DQpDUkVBVEUgUFJPUEVS VFkgR1JBUEggZzUNCiAgICBWRVJURVggVEFCTEVTICgNCiAgICAgICAgdjQgTEFCRUwgbDEg UFJPUEVSVElFUyAoYSwgYiwgYykNCiAgICAgICAgICAgTEFCRUwgbDIgUFJPUEVSVElFUyAo YSkNCiAgICApOw0KQUxURVIgUFJPUEVSVFkgR1JBUEggZzUgQUxURVIgVkVSVEVYIFRBQkxF IHY0IERST1AgTEFCRUwgbDE7DQpTRUxFQ1QgcGdwbmFtZSBGUk9NIHBnX3Byb3BncmFwaF9w cm9wZXJ0eQ0KICAgIFdIRVJFIHBncHBnaWQgPSAnZzUnOjpyZWdjbGFzcyBPUkRFUiBCWSBw Z3BuYW1lOw0KYGBgDQoNCi0tDQpyZWdhcmRzLA0KTWFuIFplbmc= ------=_NextPart_6A22DD38_6F1F9FC0_262DDA3C Content-Type: application/octet-stream; charset="ISO-8859-1"; name="0001-Clean-up-orphaned-properties-when-dropping-a-label.patch" Content-Disposition: attachment; filename="0001-Clean-up-orphaned-properties-when-dropping-a-label.patch" Content-Transfer-Encoding: base64 RnJvbSA2ODYyZmNkOTE4MDg2MDIzMTczNzZlOGZlMjRmMjhmY2ZjNGRlMDYzIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBNYW4gWmVuZyA8emVuZ21hbkBoYWxvZGJ0ZWNoLmNv bT4KRGF0ZTogRnJpLCA1IEp1biAyMDI2IDIyOjEzOjQ3ICswODAwClN1YmplY3Q6IFtQQVRD SF0gQ2xlYW4gdXAgb3JwaGFuZWQgcHJvcGVydGllcyB3aGVuIGRyb3BwaW5nIGEgbGFiZWwK ClRoZSBvcnBoYW5lZCBwcm9wZXJ0eSBjbGVhbnVwIGluIFJlbW92ZVJlbGF0aW9ucygpIHdh cyBtaXNzaW5nCnRoZSBkcm9wX2xhYmVsIGNhc2UsIGxlYXZpbmcgcHJvcGVydGllcyB0aGF0 IG5vIGxhYmVsIHJlZmVyZW5jZXMuCi0tLQogc3JjL2JhY2tlbmQvY29tbWFuZHMvcHJvcGdy YXBoY21kcy5jICAgICAgfCAgMiArLQogc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ncmFw aF90YWJsZS5vdXQgfCAxOCArKysrKysrKysrKysrKysrKysKIHNyYy90ZXN0L3JlZ3Jlc3Mv c3FsL2dyYXBoX3RhYmxlLnNxbCAgICAgIHwgMTQgKysrKysrKysrKysrKysKIDMgZmlsZXMg Y2hhbmdlZCwgMzMgaW5zZXJ0aW9ucygrKSwgMSBkZWxldGlvbigtKQoKZGlmZiAtLWdpdCBh L3NyYy9iYWNrZW5kL2NvbW1hbmRzL3Byb3BncmFwaGNtZHMuYyBiL3NyYy9iYWNrZW5kL2Nv bW1hbmRzL3Byb3BncmFwaGNtZHMuYwppbmRleCBjYzUxNmUyNzAyMC4uN2M4ZjM5N2FmYmYg MTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL3Byb3BncmFwaGNtZHMuYworKysg Yi9zcmMvYmFja2VuZC9jb21tYW5kcy9wcm9wZ3JhcGhjbWRzLmMKQEAgLTE2MzgsNyArMTYz OCw3IEBAIEFsdGVyUHJvcEdyYXBoKFBhcnNlU3RhdGUgKnBzdGF0ZSwgY29uc3QgQWx0ZXJQ cm9wR3JhcGhTdG10ICpzdG10KQogCX0KIAogCS8qIFJlbW92ZSBhbnkgb3JwaGFuZWQgcGdf cHJvcGdyYXBoX3Byb3BlcnR5IGVudHJpZXMgKi8KLQlpZiAoc3RtdC0+ZHJvcF9wcm9wZXJ0 aWVzIHx8IHN0bXQtPmRyb3BfdmVydGV4X3RhYmxlcyB8fCBzdG10LT5kcm9wX2VkZ2VfdGFi bGVzKQorCWlmIChzdG10LT5kcm9wX2xhYmVsIHx8IHN0bXQtPmRyb3BfcHJvcGVydGllcyB8 fCBzdG10LT5kcm9wX3ZlcnRleF90YWJsZXMgfHwgc3RtdC0+ZHJvcF9lZGdlX3RhYmxlcykK IAl7CiAJCWZvcmVhY2hfb2lkKHByb3BvaWQsIGdldF9ncmFwaF9wcm9wZXJ0eV9pZHMocGdy ZWxpZCkpCiAJCXsKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZ3Jh cGhfdGFibGUub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ncmFwaF90YWJsZS5v dXQKaW5kZXggY2M2ZDgwYWZkODIuLjk2MTdiNGFhM2U4IDEwMDY0NAotLS0gYS9zcmMvdGVz dC9yZWdyZXNzL2V4cGVjdGVkL2dyYXBoX3RhYmxlLm91dAorKysgYi9zcmMvdGVzdC9yZWdy ZXNzL2V4cGVjdGVkL2dyYXBoX3RhYmxlLm91dApAQCAtMTA0NCw0ICsxMDQ0LDIyIEBAIFNF TEVDVCBzcmMudm5hbWUsIGNvdW50KCopIEZST00gdjEgQVMgc3JjCiAgdjEzICAgfCAgICAg MQogKDMgcm93cykKIAorLS0gRFJPUCBMQUJFTCBzaG91bGQgY2xlYW4gdXAgb3JwaGFuZWQg cHJvcGVydGllcworQ1JFQVRFIFRBQkxFIHY0IChhIGludCBQUklNQVJZIEtFWSwgYiBpbnQs IGMgaW50KTsKK0lOU0VSVCBJTlRPIHY0IFZBTFVFUyAoMSwgMiwgMyk7CitDUkVBVEUgUFJP UEVSVFkgR1JBUEggZzUKKyAgICBWRVJURVggVEFCTEVTICgKKyAgICAgICAgdjQgTEFCRUwg bDEgUFJPUEVSVElFUyAoYSwgYiwgYykKKyAgICAgICAgICAgTEFCRUwgbDIgUFJPUEVSVElF UyAoYSkKKyAgICApOworQUxURVIgUFJPUEVSVFkgR1JBUEggZzUgQUxURVIgVkVSVEVYIFRB QkxFIHY0IERST1AgTEFCRUwgbDE7CitTRUxFQ1QgcGdwbmFtZSBGUk9NIHBnX3Byb3BncmFw aF9wcm9wZXJ0eQorICAgIFdIRVJFIHBncHBnaWQgPSAnZzUnOjpyZWdjbGFzcyBPUkRFUiBC WSBwZ3BuYW1lOworIHBncG5hbWUgCistLS0tLS0tLS0KKyBhCisoMSByb3cpCisKK0RST1Ag UFJPUEVSVFkgR1JBUEggZzU7CitEUk9QIFRBQkxFIHY0OwogLS0gbGVhdmUgdGhlIG9iamVj dHMgYmVoaW5kIGZvciBwZ191cGdyYWRlL3BnX2R1bXAgdGVzdHMKZGlmZiAtLWdpdCBhL3Ny Yy90ZXN0L3JlZ3Jlc3Mvc3FsL2dyYXBoX3RhYmxlLnNxbCBiL3NyYy90ZXN0L3JlZ3Jlc3Mv c3FsL2dyYXBoX3RhYmxlLnNxbAppbmRleCAwZTM4MWVjNzJiYy4uYWI4OWJkYzE1NTMgMTAw NjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2dyYXBoX3RhYmxlLnNxbAorKysgYi9z cmMvdGVzdC9yZWdyZXNzL3NxbC9ncmFwaF90YWJsZS5zcWwKQEAgLTU5Niw0ICs1OTYsMTgg QEAgU0VMRUNUIHNyYy52bmFtZSwgY291bnQoKikgRlJPTSB2MSBBUyBzcmMKICAgSEFWSU5H IGNvdW50KCopID49IChTRUxFQ1QgY291bnQoKikgRlJPTSBHUkFQSF9UQUJMRSAoZzEgTUFU Q0ggKGEgSVMgdmwxIHwgdmwyKSBDT0xVTU5TIChhLnZuYW1lIEFTIG4pKSBXSEVSRSBuID0g c3JjLnZuYW1lKQogICBPUkRFUiBCWSB2bmFtZTsKIAorLS0gRFJPUCBMQUJFTCBzaG91bGQg Y2xlYW4gdXAgb3JwaGFuZWQgcHJvcGVydGllcworQ1JFQVRFIFRBQkxFIHY0IChhIGludCBQ UklNQVJZIEtFWSwgYiBpbnQsIGMgaW50KTsKK0lOU0VSVCBJTlRPIHY0IFZBTFVFUyAoMSwg MiwgMyk7CitDUkVBVEUgUFJPUEVSVFkgR1JBUEggZzUKKyAgICBWRVJURVggVEFCTEVTICgK KyAgICAgICAgdjQgTEFCRUwgbDEgUFJPUEVSVElFUyAoYSwgYiwgYykKKyAgICAgICAgICAg TEFCRUwgbDIgUFJPUEVSVElFUyAoYSkKKyAgICApOworQUxURVIgUFJPUEVSVFkgR1JBUEgg ZzUgQUxURVIgVkVSVEVYIFRBQkxFIHY0IERST1AgTEFCRUwgbDE7CitTRUxFQ1QgcGdwbmFt ZSBGUk9NIHBnX3Byb3BncmFwaF9wcm9wZXJ0eQorICAgIFdIRVJFIHBncHBnaWQgPSAnZzUn OjpyZWdjbGFzcyBPUkRFUiBCWSBwZ3BuYW1lOworRFJPUCBQUk9QRVJUWSBHUkFQSCBnNTsK K0RST1AgVEFCTEUgdjQ7CisKIC0tIGxlYXZlIHRoZSBvYmplY3RzIGJlaGluZCBmb3IgcGdf dXBncmFkZS9wZ19kdW1wIHRlc3RzCi0tIAoyLjQ1LjIKCg== ------=_NextPart_6A22DD38_6F1F9FC0_262DDA3C--