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 1wRNHW-002IQ8-2Z for pgsql-hackers@arkaria.postgresql.org; Mon, 25 May 2026 04:51:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wRNHU-00Has3-29 for pgsql-hackers@arkaria.postgresql.org; Mon, 25 May 2026 04:51:13 +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.96) (envelope-from ) id 1wRNHU-00Harv-1A for pgsql-hackers@lists.postgresql.org; Mon, 25 May 2026 04:51:13 +0000 Received: from mail-qv1-xf2f.google.com ([2607:f8b0:4864:20::f2f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wRNHT-00000000eMh-0SS2 for pgsql-hackers@postgresql.org; Mon, 25 May 2026 04:51:12 +0000 Received: by mail-qv1-xf2f.google.com with SMTP id 6a1803df08f44-8acb856a674so113929986d6.0 for ; Sun, 24 May 2026 21:51:10 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779684669; cv=none; d=google.com; s=arc-20240605; b=GRBDdcGBVmZYnNhCYvpO/q6UaL234lKrUw8ipPyqKn3uoYIN3RzzkooPJ5oB6/6K8g 3yIiYOQLI1nFYh2U1WU7qyxeCCmqsQONZFZUfYz2Lt/3I3v2qY+T+DSx5lLPnQj/ZvtN Nf9SsL76iLzB2YqWa8yaUNi4Ne+2ETyMq9LEpdQxLbeMTDrdDVIh2pcarypT6p3BQH10 dofS2+km94wf2ElCYoeWjZnwZDav4MyYJ/GN0MMIboUY2aGIFmDnsaZzztZGNrNkisq6 T7Bft2goCXFRLDHo5YWFEV1yHNZ7ZipoLhtl2kwGkd5DZlfrHZJKPpd+FEM4cJcQsUeX BGQg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=+fWXKx9PJx6q1Dv/0wNc5yoj5DvHHO8+Lulv5uzBam0=; fh=JdGAwAsHWZpq7G3VjgE8a3tPThceXMzSSkvVOKeHWM4=; b=Okyy4C7X/x0hA1W8FXYrXvpt1btjxz8q+nJK1N6Bnr9cmeal3sMRwAHeVZw1MPcmNu g2r3dIP/nr1lEdgAzs8Tgiqly6nq6y+oD5xKPl5BneQimCSVU5FNtXlkMgsYHoSPRSYq L0OdZBWjRR7BaXhd68PNR6Voruv42Xo+26ZOqu4ZqxKoAR1TW+CWWQtS39nS5bOA5pOA m8/v5tPEwZ1XCRUD84PFZ/NeO92thxcbloP/IPjUKuA2qXBrmzuWWYjzHSbI87shQ3hV UAfmhtc5nVz4VXw73JO7ElGPY0cGpjcfX3hJ3p9uwjw1Umo0HoRuqvmFRyvBPx3HYdJz nRWQ==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779684669; x=1780289469; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=+fWXKx9PJx6q1Dv/0wNc5yoj5DvHHO8+Lulv5uzBam0=; b=TaYxiy/Hs8L237ozHuPS+ekjdEml2IJi17uqQWvwBIDPXh6ED3Lq8+PWVOUc/P849f h41ni6LgONe4gYybzjeW4azBt9wEnXMc15LUt+BWtBV/SqF1OX6FuMkYqX6hesPY97ik V4PB1OyIzhalJB2qNIlP6kdBFBSXcou00cSymOp7cVe0O2lKAtTv/CGtnuTazGrjAiVj sDOT9aRVJoPjKpgCHtrqMv4+2aD99SJxNYZI9c96ZJ4l2qglnEi9q3oFOBUHX9nLreYO 5dA0GZa1Ix6lJ3SObPiEQ0xOceoPRSuDy7BfoadzWnLg8euV9oGlT5VtCWDn/HDNNoY9 bB9Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779684669; x=1780289469; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=+fWXKx9PJx6q1Dv/0wNc5yoj5DvHHO8+Lulv5uzBam0=; b=rDjUxIeNLG+N3fx1NoCY+wCdH9hMV9YOJSYjpXseEY4Fr/6sRBEz4G8rAowN0DdRFe thYgrI2NQ3GH3gHiX2BKq/Lk0EArIinbzA0+wNxQt61zpaMFgA/aQf3G27PM+n+94Dki uQB/uOa4+PPcLr7rSdbamRRLksqqnl8ihsLfS9cbky0dQLbczFFg3apZe4gMwIZ1vAfO Kv2moe7/Rj+2Qv7p2q7qQo6a45kWiO9+yp4u8rCDew+KWCz1/3JeZdy3GxpB9+87nbpL Xy9cuol4QNhNz/DRHA/u9xapxdr4lhp9sh7cSbi51m1bcX0jXGXm9gn5m13jDOSN1ZxU 5nCg== X-Gm-Message-State: AOJu0YxsUkmZN47R+xqbpGEUhHVZsNrGceolYL52yCLnZl7uGkBKiObZ mCaDXEgI3q82o4mve5xEYQuEhZhRPqXvTZZP8zVTzolN9Xb4D3Flxywv+EODZwStQox6lSYDjER E0VqYpwZy0MbSVcO60dLJ79iXOM4KVYA= X-Gm-Gg: Acq92OG70tQKEHMxJGzsD2TcQDH47khhl8CqsDoOeb12I6T+mGGnbvL8gq8VDsPTSf/ yAJrB88OgA+7aXDlGLyyOc49CylS/+lWzqlU6W0N/Y/hOecPjI8HvODMfzRRHu2SkECtAMSvgRi Qm/Bihfhgad6noim7Vj82c+QTjysAl5tEJwlHe7QsQIGVJTz4xkFN18ktXoaihTiEsXnJcaiy/1 Y+PPjQDrwcodRmIdJ5XGJMdEbYObjJZU6IUb3STwFxlSAELMehbnL0Y75t3cotO7dEUgh/JxEfN fHU83nLq+gPsa0wyNw== X-Received: by 2002:a05:6214:300d:b0:8ca:256b:8751 with SMTP id 6a1803df08f44-8cc7be5892bmr195164556d6.1.1779684669021; Sun, 24 May 2026 21:51:09 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: solai v Date: Mon, 25 May 2026 10:20:37 +0530 X-Gm-Features: AVHnY4JOunU87Msmtj25NFTm7-_O_LGhhm8H1wFwbO1C-K8kvuGzqyA-COSXCRM Message-ID: Subject: Re: COPY FROM with RLS To: jian he Cc: PostgreSQL-development Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi jian, I tested the v2 patch for COPY FROM with RLS. Before applying the patch, I was able to reproduce the issue where \copy bypassed the RLS INSERT policy and allowed invalid rows to be inserted. After applying the patch and retesting, rows violating the policy were correctly rejected during \copy, while valid rows were inserted successfully. The behavior is now consistent with normal INSERT. The error context reporting during COPY was also clear and helpful while testing. Regards, Solai