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 1wXqpW-003W87-0M for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Jun 2026 01:37:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wXqpU-0007l6-2d for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Jun 2026 01:37:04 +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 1wXqpU-0007kw-0K for pgsql-hackers@lists.postgresql.org; Fri, 12 Jun 2026 01:37:04 +0000 Received: from smtpbguseast3.qq.com ([54.243.244.52]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wXqpI-00000002e3F-3LKI for pgsql-hackers@lists.postgresql.org; Fri, 12 Jun 2026 01:37:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=halodbtech.com; s=wqvr2403; t=1781228190; bh=5yV8a7UQgqLtkpo7tZaCcUr/mF2iW9J4YEPbDmokSpQ=; h=From:To:Subject:Mime-Version:Date:Message-ID; b=bhixkGIjPplKMlJ5apcF26mbLqeoM03fH2rD087BSTeuWJk4bv9dfk8DdSOLk4ZK5 E5Ov5Ckh1/23TDDnI8QbpFpFw4/D/NBCSxw7N9fRR8zAnPNFp5zq7Y1jnk6+rGQ4Bu z0IwcqH+XgnnbuhZ3A6QL4QYGTZYTm4UDMQsr9UQ= 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: y4aJRDGYKZNZ2PoXrzotYoCpfm4n8vsUkWLI9i10hy0= X-Originating-IP: 111.0.73.26 X-QQ-STYLE: X-QQ-mid: lv3gz7b-4t1781228189tb3bfde0e From: "=?ISO-8859-1?B?emVuZ21hbg==?=" To: "=?ISO-8859-1?B?QXNodXRvc2ggQmFwYXQ=?=" Cc: "=?ISO-8859-1?B?cGdzcWwtaGFja2Vycw==?=" , "=?ISO-8859-1?B?UGV0ZXIgRWlzZW50cmF1dA==?=" Subject: Re: (SQL/PGQ) Clean up orphaned properties when dropping a label Mime-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 Date: Fri, 12 Jun 2026 09:36:28 +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 References: In-Reply-To: X-QQ-ReplyHash: 2568824012 X-BIZMAIL-ID: 880713866529164531 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, 12 Jun 2026 09:36:30 +0800 (CST) Feedback-ID: lv:halodbtech.com:qybglogicsvrsz:qybglogicsvrsz4b-0 X-QQ-XMAILINFO: ODcDgdcDagQKVMnRd1jq7iZJjZTCdQcLNQHE5kzLvNXi0x8A65xounXM XMNQXk4A0XsQc3OXG7w2Z1p7muy1OYrFOddz45HP19Ei1uPcmTm+dTr0j2bOKXU3xg5q2CP NKWIIRjT6KHmh5djIdjApeRugWWhaup+qQsGMW8Hc/TX9M3PStx3r//JLVsRPc5ZJ7aYaH3 ONaTDt0U4NQgDX93VpCX+wpiSWXLhgg3R0aT0BswMQRlJE+PmiqSGZHAoczb9DQzVa2MHl0 MV/Nm+OUXtSSBkLDwZe04ZfFQ00iPJuWOTyDWxNYLPajbd11T6M3tWGpZ2ekW96qG5SzZB5 RnpIeMvATF+Dj1kicz2scalvod8RCCRwmV4b2OLtVGdyFAAhRpbXAnYgCb4FehawIamfbss mohXPnnT4f/e1w6r/FmHgUtk3ueqhV6Ot/cQJPeqlporvKfGXnrd7ewRpNE1y1pq9Or4J9q ZE6IA0KtujF/gVHZ9lqSE2A6ElUySjLvNVfcKh87s/kb9Dt6JjpEEYuFpIZv6/U4AJ/1j2X b9U/oAHwsjO+N8g0/HT07nXhZvEFnIFqFmVWRBM2QVJZ1UEtsG3Wv73Y07Pt6xejYAwZon3 kN2cHS+ys7zRdvsVTVtz/3er1VNwYVf633Hdnfun9IcXd/WROGZrn6yD2okCJGU/CR8Ol7D WYRoe1eDpAsqy7vg/FsE2W8MF93IKe2A32vv3/DFZkmMeYTxeSfUIFGcOcZ44+UXladdIbg a0nKj5n1t9S8jIKVDlkly3DmRCmH5b/QdNStZN0FHG3WeSd5I3i/z098jSgV8GrYvc2/ITi 8E97QLuCxEyM/G7XVFNt4resgPKeekFl2Xi4thZQWHrT1ZMIQdBdCNrxwRM6rJTimGb9DVq ywovS1fwWiJmyDxk6Xi4QpkHZHBfU4EkwKaFVKLyZIdySYXlAWla7703blp0d4q4mhDZf/S 2Xo8W6ljjV77l+csi1Pgs1dDOpbEtD5QK3tOFiDA8NDtqIR8rh+RynMOTehA4MPLL/KFBeK w+Uo95RnMBb0KXvy+djWprGD3nx3s= X-QQ-XMRINFO: Mp0Kj//9VHAxzExpfF+O8yhSrljjwrznVg== X-QQ-RECHKSPAM: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBUaGFua3MgZm9yIHRoZSByZXBvcnQgYW5kIHRoZSBwYXRjaC4gVGhlIGZpeCBpcyBvbiB0 aGUgcmlnaHQgdHJhY2suIEkNCj4gY2hhbmdlZCBhIGZldyB0aGluZ3MgYXMgZm9sbG93cw0K PiBhLiB3ZSB1c3VhbGx5IGFkZCBvcGVyYW5kcyB0byB0aGUgc2FtZSBvcGVyYXRvciBhdCB0 aGUgZW5kLCBub3QgYXQgdGhlDQo+IGJlZ2lubmluZy4NCj4gYi4gY3JlYXRlX3Byb3BlcnR5 X2dyYXBoLnNxbCwgd2hpY2ggdGVzdHMgYWxsIHByb3BlcnR5IGdyYXBoIERETHMsIGlzDQo+ IHRoZSByaWdodCBwbGFjZSB0byBhZGQgdGhlc2UgdGVzdHMuIGdyYXBoX3RhYmxlLnNxbCB0 ZXN0cyBncmFwaCBxdWVyeS4NCj4gDQo+IEkgaGF2ZSB1c2VkIGFuIGV4aXN0aW5nIHByb3Bl cnR5IGdyYXBoIGluIGNyZWF0ZV9wcm9wZXJ0eV9ncmFwaC5zcWwgaW4NCj4gdGhlIHRlc3Qu IEl0IHJlbW92ZXMgYSBsYWJlbCBmcm9tIHRoZSBwcm9wZXJ0eSBncmFwaCB3aGljaCBoYXMg dHdvDQo+IHByb3BlcnRpZXMgYXNzb2NpYXRlZCB3aXRoIGl0LCBvbmUgdGhhdCBnZXRzIG9y cGhhbmVkIGFuZCBvbmUgdGhhdA0KPiBkb2Vzbid0LiBXZSBjYW4gdmVyaWZ5IHRoYXQgdGhl IG9ycGhhbmVkIHByb3BlcnR5IGdldHMgZHJvcHBlZCBmcm9tDQo+IHRoZSBwcm9wZXJ0eSBn cmFwaCBidXQgbm90IHRoZSBvdGhlciBvbmUgYnkgaW5mb3JtYXRpb24gc2NoZW1hIHF1ZXJ5 DQo+IG91dHB1dHMgbGF0ZXIuIFNvIGRpZG4ndCBhZGQgYW55IHNlcGFyYXRlIHZlcmlmaWNh dGlvbiBzdGVwIGFmdGVyIHRoZQ0KPiBEREwuDQoNCj4gQXR0YWNoZWQgcGF0Y2ggd2l0aCB0 aG9zZSBjaGFuZ2VzLg0KDQpIaSBBc2h1dG9zaCwNCg0KVGhhbmsgeW91IGZvciB5b3VyIGFz c2lzdGFuY2UuIFRoaXMgbG9va3MgYmV0dGVyLiBUaGVyZSBpcyBhIHNtYWxsIHByb2JsZW0g dGhhdA0KDQpodHRwczovL2NvbW1pdGZlc3QucG9zdGdyZXNxbC5vcmcvcGF0Y2gvNjg0OC8N Cg0KSXQgc2VlbXMgdGhhdCBhICdyZWJhc2UnIGlzIG5lZWRlZCB0byBjb25kdWN0IHRoZSB0 ZXN0IG5vcm1hbGx5LiBDb3VsZCB5b3UgcGxlYXNlIG1ha2Ugc29tZSBhZGp1c3RtZW50cyBh Z2Fpbj8NCg0KLS0NCnJlZ2FyZHMsDQpNYW4gWmVuZw==