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 1wZLv4-000yCf-1R for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Jun 2026 05:01:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wZLv0-00FH6m-2P for pgsql-hackers@arkaria.postgresql.org; Tue, 16 Jun 2026 05:00:58 +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 1wZLv0-00FH6c-0M for pgsql-hackers@lists.postgresql.org; Tue, 16 Jun 2026 05:00:58 +0000 Received: from mail-lj1-x22c.google.com ([2a00:1450:4864:20::22c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wZLuy-00000000ajp-3OBi for pgsql-hackers@lists.postgresql.org; Tue, 16 Jun 2026 05:00:57 +0000 Received: by mail-lj1-x22c.google.com with SMTP id 38308e7fff4ca-39940cb1ba0so21443741fa.2 for ; Mon, 15 Jun 2026 22:00:56 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781586054; cv=none; d=google.com; s=arc-20240605; b=CnJACUcQpOL96bzW58XT0hnK5z1yyGstIhPMOcU27CJNaV0qQ2sjVt5ydS15/dFaah rWfKgsigBOqsDqVeMFqSzOW00Bs5buPWyAyWjpVU4TMJaalTkAA9H6KyBmSsx3a3UOtS 8QmMekE5GfFHBHF6GJzPsTyzwCN+sUYpWhuUwSaj6tNJUkn04mKo9kEyTsmVllpp9Ndg 9xJe/uNLSk8uphEqqVoHmyysQIeYbI3IyGgTTML5mE10oDHJyOlE9P/xeBgZCZKaI5G1 o4d//kJFG6AVMyDGSQXBJsI/7MkGV/x4Uf6YykCyBZTjFQkpmFav8PUqEtZCOr5BbZLY pFMw== 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=VYKHcHk3dXohv0mQwvYRHCwWaJ3gYZ8R1K9QJr2F374=; fh=rEmBOstzWH28XpxHTcl+WNXWKw4f37iaH0b4aDwyxPM=; b=Hxm4XyKXMYrwk3F3fQ+FL9ikFcfC8egKTuT0cZQLh9m9cU+/llD6Ikes0OU+WlSBSI X4s3Or7joYNg25d70PqXzXW9gISudaoHRsVce8FDh5pHd+oJ9FG9alzceNcXz4E9Ktek nQKfluHUFtaBWwrwCUUqropplZvxpQC41o+OE8Ktj1wj7eICdkmUNH0YiW4g9g6n0L4k qtEVjqAzEHSjdZJSSTzUM8QBmg5kRVtkEboiauaK0NlMk4x3O/iFRVmak4jkXDd61nnO CFoiHQy+iwiUnohZ2/36NflMBvj+kLRlSSNBApKpAK5/4bf1mLg/Wu7hO0/ZP5j6VPbI Xrtw==; 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=1781586054; x=1782190854; 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=VYKHcHk3dXohv0mQwvYRHCwWaJ3gYZ8R1K9QJr2F374=; b=KN7JhrRWJwZCkuoMGPE/UW00NgANmZ/om9P8zB8x2WdiXMm+V8z9tvTd9LdTH8rfd8 usKus9f1rfo3X9uESB3p0W904EFJ4/L/zl4WPHSXjdM2qPbbG/mADxluRuVKQU12pvWV nS2vgCtQ9HNm7Au0MOx9y/0D6H9i8Dvf5qXufU0FdIuxFjKKFfA5aN4jC5OZ3U3Lmfrv EJP29SvU92j/4ERNaq0p3L6yMw3tBEq89MvjVnUYpSxCHMgJEBBVYSaBHQUiKV44nrtt eS8Ih9HGSzfPAK9EQowDpAfxgl0qhpy4TFO5QmQpn4yzzt63ALd0k3pkDBgGYzW4kfUC +qHA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781586054; x=1782190854; 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=VYKHcHk3dXohv0mQwvYRHCwWaJ3gYZ8R1K9QJr2F374=; b=Zn/U8HmsR4a91rT45tcfj8zaOKOWRmYoI7RKaP65cxSl7FG0OcdOglWZBvXDr3Amen I0E4ac6hk4dyBbVR7lV0/jG2CV4mY5ohJ3LKKEzQ5mjlsdUU+9nhyH99WmnD/hbp4qzU IqWEU3QhCesenTs1kwRGqlUf9Zdpmj+NFL1yZ7FSMIolL4aCYVgFEb4MT2AxRaUzwEU1 65+DM6Xy9LrRNBWkeF9KCW7j/aTDP/H6b+cNC+PNbrWg+Tj2AW8Xasaj9pLo38P/bVuj wX6t4KLjoaId3WMGs0mysjyyKv2kyNtnFvUvhUsY4FKeWMVp/A/Asl/CVM8hXIkDp+9B Sxkw== X-Forwarded-Encrypted: i=1; AFNElJ82igT1nblYYCgqHvJI9N6gq/kdr5BFBiHjWp3UJ5KxOMnZvFT98u+nTojpgs5FY+NYNIWPN+cTdNrzsq+0@lists.postgresql.org X-Gm-Message-State: AOJu0YybwuJ7RsV6rZapQpTd9He4tCb6URPIIN1La1lF/Z+96GMJ1Rkj i8GqUG6TA5NI5q+tAoODv4DMdr698rFsTNOmLFlJxUVN4DgTBcDbsqsRXJGvGM4S58QSj2lNoVi RlvoZVIhSC22hBkMWL87261PC5mX3ZFU= X-Gm-Gg: Acq92OH4ckWQhq7bhF1Gam0ndmPL28fz0VUx/CnNRE0I7AxX8+Ur+ss9REg0BBChx/y 5q2SbIUalI8AX5WYbnuZUSjvuVGFLXVIt8Wd442aAe0c5sQBI/+G7LMlzQ3Oe+E1lmMOQa01M7S Gi9nJ+PeQiJGIg3E+wYe1hd4JrCdygXo3zTRvDZbBnGBJVPMtv7UhZgHnL6gqDCg9XyfIjb3Oh/ MEvgPMYjZaU5eNyf+t/4MHHmib228wXs/fG9Ou1mvg6ME5TbBN4lGSqnwDImfxHmNlVLFRlzrbu VpQ/97vw3JpWk+02jCk7cl3PSLR2f1NwfL5JFSrNrbhOPwELbEK8Ew== X-Received: by 2002:a2e:a813:0:b0:394:7f1:5114 with SMTP id 38308e7fff4ca-3993579284bmr39172981fa.28.1781586054050; Mon, 15 Jun 2026 22:00:54 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: shveta malik Date: Tue, 16 Jun 2026 10:30:38 +0530 X-Gm-Features: AVVi8CcbcjoJfhawCwKdO2o1lY5jk1BDGMhf3DPiP2rJP-ogBkdRvR26A3VrawI Message-ID: Subject: Re: Proposal: Conflict log history table for Logical Replication To: Amit Kapila Cc: Dilip Kumar , vignesh C , Nisha Moond , Peter Smith , Masahiko Sawada , Bharath Rupireddy , PostgreSQL Hackers , shveta malik 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 10:21=E2=80=AFAM Amit Kapila wrote: > > 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 = wrote: > > > > > > 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 o= n > > > 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. > A view is essentially just a stored SELECT query, I think it should be allowed in the first version itself. Rest (functions, indexes, statistics etc) can be decided and implemented later based on user's feedback. thanks Shveta