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 1wV0nz-001c5n-03 for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jun 2026 05:39:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wV0nw-004z1u-1f for pgsql-hackers@arkaria.postgresql.org; Thu, 04 Jun 2026 05:39:44 +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 1wV0nw-004z1h-0h for pgsql-hackers@lists.postgresql.org; Thu, 04 Jun 2026 05:39:44 +0000 Received: from mail-lj1-x231.google.com ([2a00:1450:4864:20::231]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wV0nu-00000001BQp-1bgs for pgsql-hackers@lists.postgresql.org; Thu, 04 Jun 2026 05:39:43 +0000 Received: by mail-lj1-x231.google.com with SMTP id 38308e7fff4ca-3967724bed1so2768821fa.1 for ; Wed, 03 Jun 2026 22:39:41 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1780551579; cv=none; d=google.com; s=arc-20240605; b=MwCXX2NRwv/VEfC2pCCtsSm3G8GoZ3cHjEwX747QBWIUgwCpQVK/STYDIzshJ3DFGu BghMNz/DedStZPwNzEWIVOHUDWU/1RdjMD5DogkarT8y2WEDYoRpWOH80HHrBYB6r5g8 ViYoIRXwp+NTjIBA4SX8C//PAXRuIg5LnaZjXWanu1ecyNsZuSV3AioYlfQ6wg+pJbC7 UdYOnSIfFUmQmNe+wgLZUd38bScHsjjPhzfIa+4WHel4K9mL6jFmWqlyZ5Cn+awfHg6f rNo01h2kAIYMQy805oBSwtWqCgKfOuHQcOd+G3aLh1rHBU+/d5IimxgaD5F782WfQRbe 2H0g== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=CeM7C85uFjQuTsiwE27B1Rc2qbgR6XjHNZu+6t4IyOA=; fh=EzR34ye84Fs0+sxD5jJDYQRrvekwoikV37AMGQU5t/s=; b=UDqD7bG7Bmn9Oj4GyGfNsPQDM0W+39PG7zrNMbQOqzbKj5eKkp8t2dnumcm7UHP5qh KaOoL+i0cSQ8OFEvYAJ54h3Ovjtb0pFVexynJZZo2azIz6DixKB1wzBc3PZik4VujF5S cZ3T2X/AOi4786duAqo6KrydbWWeyLRiDCy/TgdYwvaHV4/i51Qn/tPbqH/RI1i5YjOR 2I8uiNe98z3aDnMkC663HW+tYHhxjDrSy4CvgR/5jchWr1GEvJY1QD12Y6NtMsELu5RU d/wb6iDG0XVJK3fHEsW0v2iWxoQMQiMYnoFN1/gACbYs0fnqBqm+1WliCzkcQHt0TWHz N+yQ==; darn=lists.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=1780551579; x=1781156379; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=CeM7C85uFjQuTsiwE27B1Rc2qbgR6XjHNZu+6t4IyOA=; b=gbSARSeg3BJEYzfmvtfhyoWNGc6xwPBQeqOikpMtViWblVYFm8qHh+g/7GjQObYTYD cGreVjXa0GeynJfU1b9KoKxr2ERxsVIzya0iS9WBVRUb+MXW/GYQwuupz2tqlieEsnya wjPjMVpycBUdgPZ1ofwuubmIIIGfGPQ8RlcjUaapKR4PFCBtmknUQohU7iOXFtMtpZ7d CVeiWaZaIXUZvPCYiXkjDDnQpBU49VD2BEDjeEndwSkT6OLfYa02veHm1rfigtUAPcx4 //zKYeoBRl2+pUqefEghSPVMy6V3YgDb8IvKMcWKFPJ36+BAnOzfZm0ejGrth5sB107p DetA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1780551579; x=1781156379; h=content-transfer-encoding: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=CeM7C85uFjQuTsiwE27B1Rc2qbgR6XjHNZu+6t4IyOA=; b=ORyJ69LCXjY7oV7UMJwnjHKM99mD/ay0/hJJ5hDdgI98OrVscVQGaZHe5L0gSZxgef MldIyfQS3si6UUCikZ/9qcq+0tX/nIn0DLbMnlPOOvP3+1Cu4h7E51zpsNGhq05UAz0h T5p8MGfEwwljYi9NKaPNXvOqnzXAGIvwxXMiPqY8nTfzL/uJP19yI8g9ZLdstUDGKwFW 5tBXFcQrArqPMGqUsldX/c2DpUmGKRrgWEsP3lhya8icJWQnePD+wLqzCqqgoKZ6ExTp 0TcH8DUqOmXB4w9yo/uOu5iC+aMSYLOd2vlbj2APd5Wlh2XQpsf21+aTRYjn66K+w/st BFYg== X-Forwarded-Encrypted: i=1; AFNElJ++Ph3WQDBeuaxbK+hcZJxILvj3loDfiWxna0r5ZUyQiA6DyIoqLHNh/8ubzw9+I12DOdajPIYxoiLy81tX@lists.postgresql.org X-Gm-Message-State: AOJu0YzmLLv0vrNiWRU6oSP3FBnHPEsT2bNCjqaRDYT4c/Fozwmv0389 EYffEFRUPWt3WB6yH8AMcTK85xIcA5bQZTkqxNlB7VC8SNmrXvkt+MA+RGLlugv1xREhCDAH3QY U70IsN53ZjAzXTWj5demvDLx6xhVw8Q== X-Gm-Gg: Acq92OFMqnpQxdONtFyWFLo56CRSGbD2Mv3/5wlFgHKGN5c1fiKUqymLCyo+PiYjJgT 7bxY49tLhD/Z7YJQaCJL8rcdXQXn68lPLKWK4W2J/4Gcfdue+Vfbztm3g2FIPjowjoMPb5RVGxh uMhMbuhnGIXy6Ehxs4igvFW7H2PWkCE1NUfkD6cDrLRDg+47KBO4xbLtvP39dfGKPGcuhiU8qRb TkvFdK11O2wizluH6bce2/4kVoZzKXBmgicKbB0AJGzd8xtbaey0S4DLNIz2tlWmKFAmILNaMxP M12uRvgzqygSDZxGUfjvv19fMLhUPz09/S0= X-Received: by 2002:a2e:bc84:0:b0:38e:36c2:9bd1 with SMTP id 38308e7fff4ca-396af152f48mr21269491fa.11.1780551579064; Wed, 03 Jun 2026 22:39:39 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Nisha Moond Date: Thu, 4 Jun 2026 11:09:27 +0530 X-Gm-Features: AVHnY4ITm59_7fY0l66PYuEQsXAzwjq5cbvoycR2l27qsn1jZAv3Dp7aQfF1yk0 Message-ID: Subject: Re: Fix column privileges for pg_subscription.subwalrcvtimeout To: Fujii Masao Cc: Amit Kapila , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jun 4, 2026 at 7:35=E2=80=AFAM Fujii Masao = wrote: > > On Tue, Jun 2, 2026 at 11:56=E2=80=AFAM Amit Kapila wrote: > > > BTW, should we add a regression test for column privileges on pg_subs= cription > > > to help catch similar issues in the future? > > > > > > > +1. It makes sense because I noticed that patch authors previously > > also omitted this part though in most cases those are caught in > > review. > > Agreed. I've added the regression test to the patch. > Attached is the updated version. > Thank you, Fujii-san, for the updated patch. I tested both the success and failure cases with the SQL query, and it worked as expected. The patch LGTM. -- Thanks, Nisha