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 1uy3S9-003Soe-Kc for pgsql-general@arkaria.postgresql.org; Mon, 15 Sep 2025 07:16:45 +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 1uy3S6-00AOJv-Pu for pgsql-general@arkaria.postgresql.org; Mon, 15 Sep 2025 07:16:43 +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 1uy3S6-00AOJl-7c for pgsql-general@lists.postgresql.org; Mon, 15 Sep 2025 07:16:43 +0000 Received: from mail-os0jpn01olkn2016.outbound.protection.outlook.com ([40.92.98.16] helo=JPN01-OS0-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uy3S4-000VCC-2e for pgsql-general@lists.postgresql.org; Mon, 15 Sep 2025 07:16:42 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=h97dzqSy9AbgQuHXTWWkcNhVslMl0Lnx1bL6H1yEGtCw6SvOLKlzlMiLmdXJbi0ecq/Q3C9c2BFbaAcmoiKhzr9H7TI3z9LW5uiMeyWSCQ242XJP5Sxydw73vrcfwSe0gQlq8PpPGecWdk1AKjem5IVNq1h8BgxIGz0cOIs/tzMsFcLDE32hEOQrYE+of1Yz9Aqjec0jhsebhKtJmfxdeJdWllJhAKYiOqL+aKm4hUoKMm0pWHNRdRO4qXi4v2NIMywW9T7JsFf2L5+Z55cbaKPZlLTqedy5F1Pbx4AZ+2Ec/eMy4+fRQ2PveLivRLCmKGx+JiLke2N5Xn+9yCEFcg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=kPTIZUBqi3mvu2yM1VnAfdOHcCyJw9lzNozE+LYk8P8=; b=RwpHJ8FyAqN4OVaqBACKeAB1YEGjP2lzwyzyzVp/0HqlxhapQ2Gic1MoyR+0urnFOP9PpJ84opCv75GgVS5/jsePorS8DQGwj5bfTa1aXXgrbhN4ccOJkkm9yHfcwJyMu0flvkDo/ucXiS5bJprVPUkj1BhQC6oJn6Bdqi/nLzrfiss9k4RSw5w1ZjG51JjSAmUex5oXWkFJaJhJLhg+snKUktSkLGHSwg6PC9KMYFXek5xeiE8ISp3dLMR7uZACeTFH4Ct0dpaQ7looRMAfYZL7Rfd/q8s82/ZZrF9t/0/MIf0JVWty3Lwqf1BFd3BQD39CUQHFI7prxi1t/4Jbbg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hotmail.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=kPTIZUBqi3mvu2yM1VnAfdOHcCyJw9lzNozE+LYk8P8=; b=hEpjpLJygZrmJJfhDFoytCFZgwRkVXY3xztGE1/8nmkGLJ8uxg0zf51pOyXE1tES6eeCmsF60NnwFIbsceW48Ng2G1fdA4MyMScSQ3I+yfjb+GvIziczAezNhLI2GxlzZcIzA5W22FTIWLBzmx6wULTB5OwzmF43mRxp4LvVTF6Ceu3647mdmPphIF1um+DwIVONX3BaiQVkGHys1Z8dKCDNrQLWTJGmbH8GgewT+dFmx3d+mAdko8WIWHnJohnRqzSHkflGAMJ58wzoYEi5JKCL25CZrNH2hi8sSQeQv/Cg3c0t6+xexer+O1QD3XAsrwsKOcmV4cXjL6JYorMFWQ== Received: from TY7PR01MB14856.jpnprd01.prod.outlook.com (2603:1096:405:24f::13) by TYRPR01MB15536.jpnprd01.prod.outlook.com (2603:1096:405:286::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9115.21; Mon, 15 Sep 2025 07:16:36 +0000 Received: from TY7PR01MB14856.jpnprd01.prod.outlook.com ([fe80::601c:d24f:f3ca:34f]) by TY7PR01MB14856.jpnprd01.prod.outlook.com ([fe80::601c:d24f:f3ca:34f%5]) with mapi id 15.20.9115.020; Mon, 15 Sep 2025 07:16:36 +0000 From: ma lz To: "pgsql-general@lists.postgresql.org" Subject: How to use \restrict or \unrestirct in python Thread-Topic: How to use \restrict or \unrestirct in python Thread-Index: AQHcJhBU8GvXOCJymkefQlUHrXqpyg== Date: Mon, 15 Sep 2025 07:16:35 +0000 Message-ID: Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TY7PR01MB14856:EE_|TYRPR01MB15536:EE_ x-ms-office365-filtering-correlation-id: f439c261-b1ab-450e-0c4c-08ddf427ce5e x-microsoft-antispam: BCL:0;ARA:14566002|461199028|15030799006|15080799012|31061999003|19110799012|8062599012|8060799015|3412199025|40105399003|440099028|102099032|26104999006; x-microsoft-antispam-message-info: =?gb2312?B?a1dYbVVpYjRRdUhDcnlXR25iUm1CQ3FqOE1XeE9YYlVNL0xIQXdXU0M1MVov?= =?gb2312?B?R3NOWGRpSGlMZ0Y2cFljUDBPUk9hMkMvZVgydlpNWVdRTVgzYlhEancwc1dw?= =?gb2312?B?VnNsRHowcTViQU1jTFY2S1dHa3B4bFczOGNzbWNqWlNma2YrR0xzaHcyOEl2?= =?gb2312?B?dlpmLzAzTC9nNlhFbDZFSnQyclVLTnJuMHhhVkp3QVhuYjU0cmgrN1lwNkhT?= =?gb2312?B?R3lOdm5ET2tueGNnZHNlclRWTXNvQkpTMng5ZWhpcW5YeUlaM01JZnpCNndR?= =?gb2312?B?blVueVVoWGI4bG9GVU9ZcXRpeWlrcFR3UFJUc25uZkFFUnI4bjIzYmpveU45?= =?gb2312?B?RkFLTVNSVU9PZ0RkemtrUmZycldQd0dMaHVWTW11dDBzZDdGWUcwcm5yeUJY?= =?gb2312?B?SmZIT2FqMWJzN0p5cmVxczhRckFmY2FPUUkzdVFBc1lFdjNpbHpwdWlDdUg1?= =?gb2312?B?RTdKL0ROaDlJRGxhTzdGT0xjZWNUSVFlVHd5a3NhWUtEeGs1TzJSU3Q0eGlC?= =?gb2312?B?czFUemYzWndBMmlESGNFZ2tRTTVmczRZWmM0OWFRSTBaWXFpblc3NW5xM3dQ?= =?gb2312?B?T1ZocHYwT3Z2azFHQjZxNnRwQnZxanRoZTFTb2VEYVhuTDlVKzJWdlFtSDhG?= =?gb2312?B?OTEvWDI3N1M4UDgyNzRRSmlHNlNRMS9KbTc2YklWcXdqdGpWVlVzaXppVkYr?= =?gb2312?B?dzJwbnRlYjM5aTZza1p3N3JDeDc5NlFTbUxGZEtBRFNJQitqcGRnRnFuM25m?= =?gb2312?B?eHl4dllFUUV3dEdhdmFDU0RjU01EUklzbW9VZ2g5RDBndzZUTU9udjVLTmhH?= =?gb2312?B?cXRmZ3VXalBxS0ZQN09xenF6OEpDQVhnNUZDZkZoRnRRSnZiMXJJbGZjeXI4?= =?gb2312?B?YjM2bWJ2ak9uRThOOWpSa2hwNXYwMkxHOHFNMGo4T3FqMFhRWWowWUF4Vklq?= =?gb2312?B?OURRMlN3UjZxNVVUUnJuVDIvcnBIMGgwQ0czc0NWT0xoYk5xTkxZUklrOWM1?= =?gb2312?B?bjRILzYxSEhJUTVRbzA1UURjZlV3ck84TlQ4Sndpc1kyVlpoYlFaWDk2ZzBn?= =?gb2312?B?MEswZGdVRk1jYkNYTEJ1bWo5R1FvUU92ODdOZ1YwclBIWkNPdFE2cVJnMUVk?= =?gb2312?B?WEp1ejVRYjNzSHV3VUhGOUJmRzNwd2xENERMQ21uY2JlNEpMSFZqZG5JaThT?= =?gb2312?B?UjVUcFZqcFhYV1RnWWUvTXBBRjlGSTFBS1JldFVWeGdiS0lZd0R3WmVPVVp2?= =?gb2312?B?amdnSk9HbXFRNWppVVlVaU9EY2Z1eFJlNEwzYThEeVdSYzNBRkRPUmlta3lS?= =?gb2312?B?dTdkcGdXRDBYYTRaUUptVTd3ZmVPZnJQa1RDVGNOL3M4a3pYbmo2a1RaeHpI?= =?gb2312?B?UVRKYlhCUXk4MUxJM3VGTzhyVTlVUTJBNGxwZDZ6MlQzWnkzWDZGRmZNSWI2?= =?gb2312?B?bEpqcjl1a1hkUUJZTm5kcVc3OSsvdXJlS2E2aTRwZ2NmYU5VajJWR1lWQXZa?= =?gb2312?B?Vlg3MUpUZVp1YkJsanJidE5BcFZzamhNOUpybnFxU0ZrUm9WaHN0UVRXUzJC?= =?gb2312?B?andtdlRTWWhHRGFaQ1RYNXp3MytSSXJxVzR5NUw1dUFWb1ZWMXhrWE0wMytP?= =?gb2312?B?Q3BJblI2emRsY25WdmVPZk5zSmYwcXc9PQ==?= x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?gb2312?B?ZUJyL2FydERtSmpqdVE4NTVaTjgyZUZUU01iWkhyeU9EQWxvNVIvclJrOExM?= =?gb2312?B?N3dNS1ByQzU5Wjc0cUhhZ2Y4V2RWekZtNlNVKzFDbVV6VXhWRHRhQjc4cFBS?= =?gb2312?B?WTRPa2hnWXZjSmlYMEJxaFFHeEs5Um5OUW16d2pEYWxPMW0yNWJIc1Q3Ly8w?= =?gb2312?B?cTVxQVNlSnE2ZmFtTmllMnhxZ0xwdGxNZTZJWTFLQWFMUU9DV2xtZ1FoL1d6?= =?gb2312?B?TnUxNGdhTWNrbE00d0lrcUlhRWpxdWRVUXB3WWJ3UERhU3laQTd5eXh5T243?= =?gb2312?B?RElSQmc4QzNhM3lOL1VlTjFpRllmOFgrbHRVNjFKRUZoUklQSEk2UkxIOW1P?= =?gb2312?B?aWdBQXRaUUw0cU54V1FUV1FoWDJYWjI1WFFSdHdSYXd0d1YvR091SGFxSUJJ?= =?gb2312?B?UG5MeXpvdmVhVmZUTEt2Ni9ha2lsbXduVnp0Ni9KMStrR21GV0RPdWx0QmhH?= =?gb2312?B?WWZkTG01ejJ4ZStJR1djOE9OOHZOWmNML3V1RCt4ZHRKUW1VeGJmSTY1eTF4?= =?gb2312?B?VnViaDZOZ3dZN0VMQlNsWFhKdGhsL3h4Mk93N2FibXVkOE0zcnpSWml3UXRV?= =?gb2312?B?UmhtUXIya2VrbXlMVHQxZWlYOVIzMWlzY2dId0JTb085MW5sZElWb2l2TThH?= =?gb2312?B?ZDE4eDgwanM4Uk5ocVpSNkUyNzhmNGM2M0xDWXBLVVFCM2FLbEgvczZ2TE1u?= =?gb2312?B?SUY0aTFwZFBxc3J6enE3NDhtWlZZT2JEdi8xMndiQURTb0FVeXhRUnBXTyti?= =?gb2312?B?ems0dWd2UVc5cFZ3UDNjR3YwZ0hVN1RtMHNlOWhyYVlwNVpUQS8rNHIvbkJ1?= =?gb2312?B?VklYME8vNDl5R0J6YXIzNXFDbHQyUTZJd1RqT3lKYVYxcmM4YlFXZHFNN2JI?= =?gb2312?B?RmxNOWdDMkx5SHBhSHJycTB2bDIyVzJ1YmY5cHo4YWdrYTlVTEVIeUdTdDJl?= =?gb2312?B?MnN3aFQ0Y0RNNUlGSzk1NGF0Yks2dGlnZm5uUmNzOGlqRXZLaWtEYUJnTjNy?= =?gb2312?B?bU16SDV0TDlNdGFGUFhOZDN0WVBpS2J2Nmo1M0tUWHZoWE5NU3ZtcndMdFdD?= =?gb2312?B?NUtFKzl1Y0VwYWtuQ3MwMkh3S3lrTW5xOHN3bWVhWG9TWXhxcUd2MFZrSzlB?= =?gb2312?B?RDBqVFpLemJzVFFGQzVrUnJuL3pXVU9ONUo0ei90NEVDN2JMMWZyYThBY2lz?= =?gb2312?B?ckxxRGNjNnpGWGJSdDZtRGdTV0s3Zjc3Z2lRNGJvb0Y4UFYrcXJFclRtTVph?= =?gb2312?B?UTBFRFBic29Pa2ZEQnlCWVd3WmpvcmhBQnhzZUNUL2d2QjJNcUd4dG5RQXIx?= =?gb2312?B?TzZCU254bDFLY1lGV2tRYUlTbFdqRDI0c2tiZzV1SFJUYkJ4aXpraStKaVd2?= =?gb2312?B?ZHFQWE44MUpUU2tpbmJDU29Ra3ZWUUIzVDdvRUVsMGZMaWNTcHNqbi9RR09R?= =?gb2312?B?eFRSYkROYVlLa0tZZmtiS3cwQjhwTENUc3hoYWl2VXV2NDIwZnBqbXJ2dzRs?= =?gb2312?B?dEo5amhHZERzUFA3aGNZMURZb0UvemZ0MDFOS1d0QU4wazBRQkVDMHJFaytD?= =?gb2312?B?a25TWGVjSFgzYk8yQ1NaS3k0QXc5MVh2RWNNUzJMRjB6UDNIeURhQlNsSjc2?= =?gb2312?B?blh5YmVJaG5vdnc3dDlFYyt0OXUrNkE9PQ==?= Content-Type: multipart/alternative; boundary="_000_TY7PR01MB14856A5E385BBD81F8DAB2D64F215ATY7PR01MB14856jp_" MIME-Version: 1.0 X-OriginatorOrg: sct-15-20-7719-20-msonline-outlook-9a502.templateTenant X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TY7PR01MB14856.jpnprd01.prod.outlook.com X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: f439c261-b1ab-450e-0c4c-08ddf427ce5e X-MS-Exchange-CrossTenant-originalarrivaltime: 15 Sep 2025 07:16:35.9039 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYRPR01MB15536 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_TY7PR01MB14856A5E385BBD81F8DAB2D64F215ATY7PR01MB14856jp_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 VG8gZml4IENWRS0yMDI1LTg3MTQsIFBHIGludHJvZHVjZSBccmVzdHJpY3QgLCBidXQgaWYgd2Ug dXNlIHB5dGhvbiAoIGxpa2UgcHN5Y29wZzIpLCBpdCBkb2VzIG5vdCBzdXBwb3J0IHNsYXNoIGNv bW1hbmQuDQo= --_000_TY7PR01MB14856A5E385BBD81F8DAB2D64F215ATY7PR01MB14856jp_ Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable
To fix CVE-2025-8714, PG introduce \restrict , but if we use python ( like = psycopg2), it does not support slash command. 
--_000_TY7PR01MB14856A5E385BBD81F8DAB2D64F215ATY7PR01MB14856jp_--