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 1oYoba-0006UX-L2 for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Sep 2022 13:08:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oYobZ-0000GH-Gs for pgsql-hackers@arkaria.postgresql.org; Thu, 15 Sep 2022 13:08:33 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oYobZ-0000Fx-86 for pgsql-hackers@lists.postgresql.org; Thu, 15 Sep 2022 13:08:33 +0000 Received: from wout5-smtp.messagingengine.com ([64.147.123.21]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oYobW-0003im-5H for pgsql-hackers@lists.postgresql.org; Thu, 15 Sep 2022 13:08:32 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.west.internal (Postfix) with ESMTP id 142A53200AA5; Thu, 15 Sep 2022 09:08:24 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute2.internal (MEProxy); Thu, 15 Sep 2022 09:08:25 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:reply-to:sender :subject:subject:to:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1663247304; x=1663333704; bh=a J5HabSd2zGQXFYaNtVvBeeMoUGnRpuTFwtNxUlOUGU=; b=ZWQZr3JS2+eWlocI+ Hqz9SYT82KgNWdLsu38rN1BvwA0pyEgcFhSOt5R1TDBNaynhgGI8rE5n/UN+cfCQ SEprqJBcXgoJ2HCTv20hTMux51wtmsBdgHfaHAM9OZ0Cn6D4Eb8G7bdmVHM46LdN vVxz+azvsPMJ7i7t7W7H+ThdlRD5rCtDmpQApzo6TZOL/42caF9A/YV9d/cfd/M8 do8MSYiQmHSEFNnUmXzz18GUOvfA/aQpd41IcvGtZ9FdN+XXAg1kUDUpr1sVX+jR RnCNGdhsChWFxBF+d4lWcQDdxnbGijpF+crLx9cugttOxpdlcZqeBMRXCWrVi+rk i4nag== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrfedukedgiedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepvdektdffudfftdffffehfffhjeejhffgieeuueekjeek fffgudffhfduffffueevnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomh enucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhv hhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 15 Sep 2022 09:08:24 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 856A335F; Thu, 15 Sep 2022 15:08:21 +0200 (CEST) Date: Thu, 15 Sep 2022 15:08:21 +0200 From: Alvaro Herrera To: Peter Smith Cc: Amit Kapila , pgsql-hackers@lists.postgresql.org Subject: Re: pgsql: Doc: Explain about Column List feature. Message-ID: <20220915130821.t3qacw2azuyovjrs@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2022-Sep-14, Peter Smith wrote: > On Tue, Sep 13, 2022 at 10:11 PM Alvaro Herrera wrote: > > On 2022-Sep-07, Amit Kapila wrote: > > One more thing. There's a sect2 about combining column list. Part of it > > seems pretty judgmental and I see no reason to have it in there; I > > propose to remove it (it's not in this patch). I think we should just > > say it doesn't work at present, here's how to work around it, and > > perhaps even say that we may lift the restriction in the future. The > > paragraph that starts with "Background:" is IMO out of place, and it > > repeats the mistake that column lists are for security. > > It wasn't clear which part you felt was judgemental. I have removed > the "Background" paragraph but I have otherwise left that section and > Warning as-is because it still seemed useful for the user to know. You > can change/remove it if you disagree. I meant the Background part that you remove, yeah. Looking at the rendered docs again, I notice that section "31.4.5. Combining Multiple Column Lists" is *only* the red-tinted Warning block. That seems quite odd. I am tempted to remove the sect2 heading for that one too. I am now wondering how to split things between the normative bits "It is not supported to have a subscription comprising several publications where the same table has been published with different column lists." and the informative bits "This means changing the column lists of the tables being subscribed could cause inconsistency of column lists among publications, in which case the ALTER PUBLICATION will be successful but later the walsender on the publisher, or the subscriber may throw an error. In this scenario, the user needs to recreate the subscription after adjusting the column list or drop the problematic publication using ALTER SUBSCRIPTION ... DROP PUBLICATION and then add it back after adjusting the column list." > > Lastly: In the create-publication reference page I think it would be > > better to reword the Parameters section a bit. It mentions > > FOR TABLE as a parameter, but the parameter is actually > > table_name; and the row-filter and > > column-list explanations are also put in there when they should be in > > their own expression and column_name > > varlistentries. I think splitting things that way would result in a > > clearer explanation. > > IMO this should be proposed as a separate patch. Some of those things > (e.g. FOR TABLE as a parameter) seem to have been written that way > since PG10. Agreed. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "Aprender sin pensar es inútil; pensar sin aprender, peligroso" (Confucio)