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 1uy8Nf-004KM9-Eq for pgsql-general@arkaria.postgresql.org; Mon, 15 Sep 2025 12:32:27 +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 1uy8Nb-00BRcr-Vo for pgsql-general@arkaria.postgresql.org; Mon, 15 Sep 2025 12:32:24 +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 1uy8Nb-00BRcj-Io for pgsql-general@lists.postgresql.org; Mon, 15 Sep 2025 12:32:24 +0000 Received: from mail-oo1-xc2c.google.com ([2607:f8b0:4864:20::c2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uy8Na-000XWA-0o for pgsql-general@lists.postgresql.org; Mon, 15 Sep 2025 12:32:23 +0000 Received: by mail-oo1-xc2c.google.com with SMTP id 006d021491bc7-621cc387bb8so521543eaf.1 for ; Mon, 15 Sep 2025 05:32:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757939541; x=1758544341; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=zyFH1a+OQqzAgj8qUJQkYTd3KQR0jVSouv36vU/y40w=; b=NbWsvHVmIq22QMvJi3l38SFm0xDTVXiOJwViKsh1LNnWxdcZurLw6nIn043gektwDT FcJXJF4H320K1h/b/hkO7Nk2zMNwAoSApZZ2rf9PXQnNxtPup6tYC0lEr7DXWVSpZT/L akSSuIceucCGMW4JiJYhWLP+HCxbtkhQjMTGY7SxwKL7CKU7Rq5ZoBAeqiWAMZIL6Ebz 8p7pv9ahdqNfC5O4QxgYJIU/f6g6XaFXG8v/I2Qxv8di7+6ewdlsP4aVqXeBXAVNbyBs MJzHUh6mJmELkLq3X+fQJj6jFrq+ZgBxykwyzWwir76dNwYnJh75WSasFGx2Y/aOOkhL VpXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757939541; x=1758544341; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=zyFH1a+OQqzAgj8qUJQkYTd3KQR0jVSouv36vU/y40w=; b=TIRsSR9B171gV4fNwjdEKHLt+vH7c15KLw0HOX2G+RDgQRfGmQVFGbvfaNJyewHHp2 7CxswKb06MC3/L0fHo4eR1SnqE0mGfj4h1xS5PafMy3DzafhLOmIsfHjyZu9EHz2xXIc EadA3dlI6CjrjkTXAGv8a8LE+ENNO1+BVE3t9xluqlJnUt7CRz78rhDF4pK/DuxUfxdu WfwtnScyM2NQHZKfSzZN7Gr3GRi4CasnxripsMTrMehMOS5ofNFKRUxrodX/R+jtddJr W0Ev3XKuBwb7IugDmOM98qB6eqwh0pLGvTB4SSm6lIdEbhR/sr/ncCX0AuhKLTXFv6aT e5ug== X-Gm-Message-State: AOJu0Yz5k5KY3hd0tX7CDLLgK4FURXyrceQ2gqwJCUCxYi7o9tDzgUcF 34N/aHyN34D/BF8Fbx8tVsGHJoGkFn3vkTPE+IaWipUop56D7ITPYt2QwfsHSaXgmB8es1bzj4c ktnscLUECf6B80En1RGvzD7SZKqRtxcQ= X-Gm-Gg: ASbGncsD/8aBiNovLEGJAO2ooZsVqagHLgvzGAYoxU06vI8mIiVvNsIujNnR2ECtJwt 8egLgeyZdRY7Er06jnS7uoelglarS3+iUFK3+n3Z5s7mKtC/LRKK/MZJkGS4Bpy+gzIQFCk66eV sNkTaE/imfTZBy2I0mFSIUvb8N5cEDhg9IPf4mmFb9yik4IjXmGb9fZrmjW7JEMQ40tZPcEQwle +u4Sw== X-Google-Smtp-Source: AGHT+IHEqsVsvULzFH+fnHjOewjtLrszBz/fKXbKeorwYHcQNLZcgo4KkzwXYIsrwovD9x0vHh6rmL25ac+aaSxFHHo= X-Received: by 2002:a05:6820:2289:b0:621:a72f:2aca with SMTP id 006d021491bc7-621bed5d08fmr6579996eaf.5.1757939540053; Mon, 15 Sep 2025 05:32:20 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:34ce:10b0:5df:b5f6:b71 with HTTP; Mon, 15 Sep 2025 05:32:19 -0700 (PDT) In-Reply-To: References: From: "David G. Johnston" Date: Mon, 15 Sep 2025 05:32:19 -0700 X-Gm-Features: Ac12FXy9qkh5el1QHzo2RUuBtMDtV48LqKzk8lr9Gtwo0XP0NNGblIACzkoJ7gs Message-ID: Subject: Re: How to use \restrict or \unrestirct in python To: ma lz Cc: "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000d264b1063ed63127" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000d264b1063ed63127 Content-Type: text/plain; charset="UTF-8" On Monday, September 15, 2025, ma lz wrote: > To fix CVE-2025-8714, PG introduce \restrict , but if we use python ( like > psycopg2), it does not support slash command. > Great, then you are unaffected by the CVE that targets the psql application. David J. --000000000000d264b1063ed63127 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, September 15, 2025, ma lz <ma100@hotmail.com> wrote:
To fix CVE-2025-8714, PG introduce \restrict , but if we use python ( like = psycopg2), it does not support slash command.=C2=A0

Great, then you are unaffected by the CVE that targets= the psql application.

David J.

--000000000000d264b1063ed63127--