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.94.2) (envelope-from ) id 1u2q1z-006fX4-NJ for pgsql-hackers@arkaria.postgresql.org; Thu, 10 Apr 2025 11:25:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u2q1x-00AeUr-SO for pgsql-hackers@arkaria.postgresql.org; Thu, 10 Apr 2025 11:25:14 +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.94.2) (envelope-from ) id 1u2q1x-00AeUg-GZ for pgsql-hackers@lists.postgresql.org; Thu, 10 Apr 2025 11:25:13 +0000 Received: from mail-pj1-x102b.google.com ([2607:f8b0:4864:20::102b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u2q1v-0042vO-2e for pgsql-hackers@lists.postgresql.org; Thu, 10 Apr 2025 11:25:12 +0000 Received: by mail-pj1-x102b.google.com with SMTP id 98e67ed59e1d1-2ff64550991so557628a91.0 for ; Thu, 10 Apr 2025 04:25:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744284311; x=1744889111; 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=5hojTkqCzQ17dWTDX1vXCKhLlNl/Djpsveyr/k0Cvuo=; b=AEzZuhUnxJOWWXOtSDEP/e9J/sjy205zexOnRiGZ24ZwcjKD7EDz8ZGJo82IsLCk/a iS6nKvhPRAwpNDU7rYTM5zUcAou4okeY4B9iJotF82KjkbUF1M4HwF6TlATxUDyD9bsx pSAiI4OOdJqohH9G9G4GQMVi0b40sm29ufwnoz0PaJL4JUg6qcrB65vqVfJOpJwkYjCH pr2PGcxXFvnpwCfXyqriZrRSDHlz56QCxNgstM+daxNrbzqLVXIW53IN9dBYZPyYK8wK ATm12ceLxofXER3rHRtSGp/TK/EklUkZU+wn6gazexniOsFXnTnDuUesrTXlL3dfyaXe ICMw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744284311; x=1744889111; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=5hojTkqCzQ17dWTDX1vXCKhLlNl/Djpsveyr/k0Cvuo=; b=k48hW5fMFy+RiSNYhooLO0r0E93+eUyCHeqhOJdz+b3mZEv60gq1DBRt1H1jNCmAsC iXb8iysMsUi+xaoQZTrHcb3fRenJVYXepYqhVDq+Nl9QJjcb2z2NyQQEgxyAjVPV1NU3 /ed53ArTXQUkAlab6eaABQhZTcO7xa2S6EscAmDuLTqUrgC3g8VuFgztEH3mT3kh31iD V0/sxhzzMSlLn9DnCWMWSAkLvSZNl9iRFcMOZ6AH1ju7tDTNq26eyhdSb60E/GSEuZkn 6+kiKiJyeH07fDKc0SgGUiNmWWGF58xZ3w51HYC2mWkzln8mng4L6rFY9sLSYbR6RFgp ySmA== X-Forwarded-Encrypted: i=1; AJvYcCUfQ+T+4DetwWKwBWPag5K7M1/uZCcVdvnlSW0YrHufvzOkXfeofTmYyyKJkDpliHb8K00x8AYEQ7y5tw3P@lists.postgresql.org X-Gm-Message-State: AOJu0Yyn7ZoR2CNrcS8gQ1XiGRkFYZgr14K7w4Cmwqls+Atsf2R1v1iJ ahMXY4fPBV1E8+4CJhkkRI95KWXtQc04bH5i6A8LS1ynaRfAJCxZ48DllK9Z7tunqWNdAkyvlt1 WaaTTj+bQ5oVeL7TzkI11zlSuvd0= X-Gm-Gg: ASbGncsYIyMJa89LHrut24djPLMqf8yf6Fc3dAxcUYv881EbffVQir3vSPCDPdlUdd/ bo1B6fUXW8yjysaYkbwjtnDQ8vpyEVPj1DoIpEJdLfWQA8nE23yt2byA9l18aKGIn8qtv7P8R5m MntFin3mMQ8mEGyjmbwlliIn0nLpSK4iWnPKA= X-Google-Smtp-Source: AGHT+IGBf1IqGOroPQrUE2msREuXxrXGSPLrXl9Iea0mjrbJJeaU0v3iuok+NmsMlFjGjGrX5qNfZ90Bhtu2EACVaiI= X-Received: by 2002:a17:90b:1f83:b0:305:2d28:e435 with SMTP id 98e67ed59e1d1-307e590aa11mr3184004a91.7.1744284310463; Thu, 10 Apr 2025 04:25:10 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Thu, 10 Apr 2025 16:54:57 +0530 X-Gm-Features: ATxdqUF9lHivBLZcw_kT3QFWoqNbuLqrF6XgrX-q_plKjs8ySXy1IE0EgHOWqvg Message-ID: Subject: Re: Skipping schema changes in publication To: vignesh C , YeXiu <1518981153@qq.com> Cc: Ian Lawrence Barwick , Peter Smith , 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, Jan 9, 2024 at 12:02=E2=80=AFPM vignesh C wro= te: > > As I did not see much interest from others, I'm withdrawing this patch > for now. But if there is any interest others in future, I would be > more than happy to work on this feature. > Just FYI, I noticed a use case for this patch in email [1]. Users would like to replicate all except a few columns having sensitive information. The challenge with current column list features is that adding new tables to columns would lead users to change the respective publications as well. [1] - https://www.postgresql.org/message-id/tencent_DCDF626FCD4A556C51BE270= FDC3047540208%40qq.com --=20 With Regards, Amit Kapila.