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 1wZLlZ-000y5G-1Y for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Jun 2026 04:51:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wZLlY-00FEub-10 for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Jun 2026 04:51:12 +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 1wZLlX-00FEuS-30 for pgsql-hackers@lists.postgresql.org; Tue, 16 Jun 2026 04:51:11 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wZLlV-00000000eq8-46kx for pgsql-hackers@lists.postgresql.org; Tue, 16 Jun 2026 04:51:11 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-bebb72b845aso698030966b.3 for ; Mon, 15 Jun 2026 21:51:09 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781585468; cv=none; d=google.com; s=arc-20240605; b=N9qgY4NzEoKW048PPnPaKh27WhMaFRNKu231NEiEpHEZGUWjrGpsMmi2mPjN5n8aJ9 1uTO62rww82xX9Pi5DhSH2lQHb+UuzeUpouHDQOqxYjkNJ0WnGb2KWr/hDQ7m+ZQAqyV UMmqhpBBGjmcNBT96qvz0ojPjLpM4TMzpSzUTh7hn9okVIcIjAemwgprzAb0/MpYrWzS QLH60dHFD9vsi/p//UukWtq/oOofIoEkHMbgUqrfpmxJyswsbdTkUpJz2zCpRMc+rtmV 6LlX0SnZIhvUubqAq1LrkpieluetepI0sMngi72sJUKhIIqUWHwCSl8DrH2Hgz7d9Eq3 G9hQ== 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=cSb0gt3+LtKyxqOtIDkA7naEaVU8xshBzjG1SQTcHSU=; fh=yqcnwIs/X+JpOrvB0XbTwNvKa4uxcNcetCeYcb1N4R8=; b=XW9kocBDwrGDCnJCHeQx1WjIIp9Tg4kGOClPsKCwAcGWsLwQWD4r2mEWrNPBIxM2Qu qMYtY+xpVUMq4gumJuZ2Mgn/mGJ0T00mO0hVru1dGy1T4jFuZXgZtlS5UNXYtzOo+U9l S2kQkFSsjUbvI8RoUep1K4/Of1Dh7b8JJRdVakkAmcSAuhgDBzJywz9eNisaEeD5nsZJ EarV6wTu8wlrCkuOD7oxjNhIcOH5m/aoT36J13yNIxtprNgBD2BELbC+s1keCKijChzP l25ObnY0hdLXfnldWAaVXIl6kwW+bVWJ3YfWjzY4mtVeINSCgo9hHahmjM54st/3cgUo Kcbw==; 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=1781585468; x=1782190268; 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=cSb0gt3+LtKyxqOtIDkA7naEaVU8xshBzjG1SQTcHSU=; b=G3clhpCaaXcdM1GjC4W44auiHfJUni5mVus/vYJGs8j1ckOlR0T2H4apSrSeqKE/ei 39qEr4iji7DqMztnZJch7p6IkXFY/t/D4vXmtZ69x3cAARE7QE2+U8Ux0GzpxZRprjLv 0/URct8CjLjEY2YYLnSbIB8c9VJgVRAMoP2NVhUpib0PR0AIxrJXerXYzfxDbcW3fJga hEkHBwAFoSMR2S5G4hRREe6rg5uZeRtYLwVHT5+tt2QuwFeT0gDthA0Xr5bDs4RXvd0n +AaOeTWC/wsh8KUpCxiK18rSXh2fBWzZb/4QZGHj8vnnghcQMzLzcvBmrL66hbHXke5O TiaA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781585468; x=1782190268; 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=cSb0gt3+LtKyxqOtIDkA7naEaVU8xshBzjG1SQTcHSU=; b=gADBkbcxIu63Gr8XT52j/5JJyF6L7CAKUCwpWZ7YP0UZ8DDTAReV0GXj5omNcpNGv4 jeccSt2QneN+alQT83HDXKU2F33URlnTYR6rkyOLU2GEaTk+40Z8/GP0l4QYC1kRS1KW QauM3a0KE4fBEgyFTvX0yH5UB87vHWgI6kj3XMHf/GPHktM2S8v6uX70la3dkHf3MgHj 11uZ1XRC3eLpHCu1T5Fu2FY+MdM+FwD0oe6JeBEaJWvjeLSbRPIVbiknF9fg4fPoZmWz 8hUR//G/pUFIElxlgs9CaNzMGMSfzwy9cJ3KVCFMsEWYFLXyg1GT2G9EdrkX8pxpd5c5 0sSA== X-Forwarded-Encrypted: i=1; AFNElJ+1oCQg8x4LulXn9mJ9bbGGv2Lp6fQMIgBt+NO2ZimK6rW7VYdl+0RiTPsMKKkv3uwcsxmgi0arXH454jiB@lists.postgresql.org X-Gm-Message-State: AOJu0Yxgk5mQohTXpo4fBWtqzvTtne8qKMxPe6/WL77Fw6tuUhSI5g5X CCmaACv/EE3V5PEwW0imvVmtUC9ZEkd7Re2O7wLHqYyS5CAjHDk2tCLiMIyqfaB3uvgeS/VA75O SyLMOc8qUvMsdB6U8ZwQx2xK5dps0F5Y= X-Gm-Gg: Acq92OHdgXGVqbyrbecYnMYrNv+XuOLIay4xdFuQbUmpP0GOdCAWM0Ea2fUbp7cSkD5 n/Djgg/CClzD15PNSnL71cFTNw7VvkITQRB6VsqLzP3ev7Ptn3YrHPRiUc1f725d/AE/voH2wvC gdG0Tfxzv5X2qU9GuVGReupgxeCTW/zqyItKqpcJ8MkbknM7vLhjXRxW05qhDy4AsBkCdsZVjow W1iQG+EmckSIo2Gj0YUOyM0HGP9AVh4k21r86slVz3Zh6fTJZuJpRBWVTGHlJBSqPeirIZFB3Ha 7EYh2M796CLtECvXdFFhBjFYPfpmmNzXTXRm129JrWdveXT3zPLXLYqWQ4WZ3/wp0nLr/pPP1Df ncIBjkPo= X-Received: by 2002:a17:906:844e:b0:beb:2de3:1ba3 with SMTP id a640c23a62f3a-c043ad415b1mr61651966b.2.1781585468234; Mon, 15 Jun 2026 21:51:08 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Tue, 16 Jun 2026 10:20:52 +0530 X-Gm-Features: AVVi8CelHcdTpctRNY6dHpILmUxvzXHOArcX3EipLLR8c8axiw1T5R_Y4JXyzOI Message-ID: Subject: Re: Proposal: Conflict log history table for Logical Replication To: Dilip Kumar Cc: vignesh C , shveta malik , Nisha Moond , Peter Smith , Masahiko Sawada , Bharath Rupireddy , 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 Tue, Jun 16, 2026 at 9:56=E2=80=AFAM Dilip Kumar = wrote: > > On Tue, Jun 16, 2026 at 9:27=E2=80=AFAM vignesh C w= rote: > > > > Shouldn=E2=80=99t creating a view also be allowed for the same reason? > > > > The function is permitted because it only performs a SELECT on the > > conflict log table, and such read operations are allowed. A view > > likewise represents a stored query definition and does not modify the > > conflict schema or its underlying tables. Given that direct queries on > > the conflict log tables are already permitted, allowing users to > > define views over them is consistent with the same rationale applied > > to functions. > > Whats is the behavior of toast table w.r.t the function vs view? > I think sticking to the minimum set of commands that are required for the user to monitor/maintain CLT should be a good goal for the first version. We can evaluate to allow other commands based on real user need and its impact on the functionality. So, it is okay to block even the view on CLT for now. --=20 With Regards, Amit Kapila.