Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mTsDc-00084O-I5 for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Sep 2021 20:54:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mTsDb-0007Ui-8c for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Sep 2021 20:54:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mTsDa-0007UZ-JO for pgsql-hackers@lists.postgresql.org; Fri, 24 Sep 2021 20:54:51 +0000 Received: from mail-ed1-x52d.google.com ([2a00:1450:4864:20::52d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mTsDX-0003nF-Hd for pgsql-hackers@postgresql.org; Fri, 24 Sep 2021 20:54:49 +0000 Received: by mail-ed1-x52d.google.com with SMTP id g8so40803339edt.7 for ; Fri, 24 Sep 2021 13:54:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; h=subject:to:cc:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=0ea7bzo4ixjmH2BQOutfwtIivPbSsaXMwq313Ii6Vs0=; b=PNuifEMaWLO1L7SMPpQbQ4qxA64FlmCZA5z/ctDcWtnubS07guPKCmVp5HwAyaeHOh u+9Nl2II4WFVVRFweDMi3uhjmP6V2vgNBdTeBBv66synPoLFkIMmJtNxIR8TzyG8IpHH 1qcHD+H/8fpATsdo9tiqErMYFX8t0YlYymUnVZdT2MjfspiU8h1wL/s4O3ki8FcwXyhK EvcHNxzBLhES7HZYW05Uh+bR0gxF72EtJ/UyYrBQB1ddJbmrPCbOLIhxY5Bdf0URmDtc wv6mq9pQ7mkJtL1K3BooL2seQ+IybnKr/mCem1KshcM1cEPwjiMoisrqwh75R7ALkkTG yhEw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:subject:to:cc:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=0ea7bzo4ixjmH2BQOutfwtIivPbSsaXMwq313Ii6Vs0=; b=wl15adr3V8iqWBFCwpY6lLXr8TCHWVUfpDr8RE4ed+JNZnnr1WN5eiPUTmOoCfhK4A 95qFcEXa6HwjT/9T+io00o43DCIwDXGVAA1nmGgBOT7dDLhToS4+eGra1zeryr3ItG+z wDZ+07BAR0GilVVGqW+zbxdQ7Zb8jP9LHxmtpCZ1YuOjLEb5OkBnWhk5t2/5suXBWoVL UyL7+VATC/yh300ZKw5+9lK6Lf7NYmd3NS54TCUgePzL/i7jn5KkW2U8PbAiY1QnHbEB 8t8fGlWVafpNaR+s1c2ieCz4qKAs//qdTbo69lqjAjVWkJRzhUqMjK3hIClrAWK3eX+J 9Spw== X-Gm-Message-State: AOAM5310PPYjKwPKzGAWPQ6Kmp9ew1MLEEinyTnCrLYoAqDOMn2RqvRk HGC/6weKC8G+TU7wOdp30IgTbrIeB+36KMt14c0ah5YgL6zkX1iK4P5hLWpeMHvJwJrSrE7etjN 6COlzZpx2VpC1VO4+cMkKGBXSubx3Es3DJJMJxoBJGxrBzRPrik0bhxhd8jjfjaoYYQNPy0yCrY 16QIGU2f5/DO7IXWI9rnW/Hom6YjF9YuyBYeGwld+/PISwtHxIhWjkyRymcQj1nIMuAqlRtJ1hS b7cHgABVxgs2RdXFdVsKhjSpuLqIzoXm170pw== X-Google-Smtp-Source: ABdhPJztgmRV+/09GDljCMg+CtoO4Aj9BYA9Q01EgQbyEt9mmgL2qrOHrwtbNbkbdedQ4FDniwOnTQ== X-Received: by 2002:a17:907:6004:: with SMTP id fs4mr13235566ejc.567.1632516885248; Fri, 24 Sep 2021 13:54:45 -0700 (PDT) Received: from [10.137.0.18] (ip-86-49-251-104.net.upcbroadband.cz. [86.49.251.104]) by smtp.gmail.com with ESMTPSA id bx11sm5739488ejb.107.2021.09.24.13.54.44 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 24 Sep 2021 13:54:44 -0700 (PDT) Subject: Re: Column Filtering in Logical Replication To: vignesh C , Amit Kapila Cc: Alvaro Herrera , Rahila Syed , Peter Smith , PostgreSQL-development References: <202109151150.2gbvjmwvgoin@alvherre.pgsql> From: Tomas Vondra Message-ID: Date: Fri, 24 Sep 2021 22:54:40 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.11.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 7bit X-CLOUD-SEC-AV-Info: enterprisedb,google_mail,monitor X-CLOUD-SEC-AV-Sent: true X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 9/24/21 7:05 AM, vignesh C wrote: > On Fri, Sep 24, 2021 at 8:40 AM Amit Kapila wrote: >> >> On Fri, Sep 24, 2021 at 12:45 AM Tomas Vondra >> wrote: >>> >>> Hi, >>> >>> I wanted to do a review of this patch, but I'm a bit confused about >>> which patch(es) to review. There's the v5 patch, and then these two >>> patches - which seem to be somewhat duplicate, though. >>> >>> Can anyone explain what's the "current" patch version, or perhaps tell >>> me which of the patches to combine? >>> >> >> I think v5 won't work atop a common grammar patch. There need some >> adjustments in v5. I think it would be good if we can first get the >> common grammar patch reviewed/committed and then build this on top of >> it. The common grammar and the corresponding implementation are being >> accomplished in the Schema support patch, the latest version of which >> is at [1]. > > I have posted an updated patch with the fixes at [1], please review > the updated patch. > [1] - https://www.postgresql.org/message-id/CALDaNm1R-xbQvz4LU5OXu3KKwbWOz3uDcT_YjRU6V0R5FZDYDg%40mail.gmail.com > But that's not the column filtering patch, right? Why would this patch depend on "schema level support", but maybe the consensus is there's some common part that we need to get in first? regards -- Tomas Vondra EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company