Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i0Qv2-0006hj-LR for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Aug 2019 13:44:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i0Quz-0005No-Op for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Aug 2019 13:44:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i0Qux-0005HQ-7M for pgsql-bugs@lists.postgresql.org; Wed, 21 Aug 2019 13:44:52 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1i0Qur-00017Y-Ec for pgsql-bugs@lists.postgresql.org; Wed, 21 Aug 2019 13:44:49 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 3F08B22185; Wed, 21 Aug 2019 09:44:44 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Wed, 21 Aug 2019 09:44:44 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=xP0m1nPxJSj/UNeZQetreaoZVGK mJ3O3PKzPaQGi7Mk=; b=syeMnaDa3cz9pPnDpzhyyebk/QKkeOtr39MVB7x3aFu 8QN+Ywo6Cgsl+BFw88l+5vAQAdc/o4/qGSIBJspwKFW2Y7ogCC95p3eOgTysu17h 1fpBeh2eqTYCPkscugPh+Gb7Nwr401ydwD/LnZcvTIU3OJVxL7SseOf1MNeSDbJi ysqHObhylON6dor5VHjruZAUdRuKB+ShsyD2RVlAbWDdQiKMpa4Ee5yOuFS1PQ4Q 8I+pHY+gTgv86DHcVMupTmYfTMYgJzsSrtoejJ90qDXTJwrNG9qoV9wehH0OoB+m 91Z69/zkyWTqiw6Qz61RJkb2ZfL35DeAsi/TTwg5KfQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=xP0m1n PxJSj/UNeZQetreaoZVGKmJ3O3PKzPaQGi7Mk=; b=jiCNoQrie/X1u2BL1nyIr2 GyIMgNKOFW7yiekGWA0wnPhnus/vlLYd1zLkVXR5EkD/7HMupokz712eqfMQoFsJ VxKPchRX+zaWhY7Kon49mizQ7zSCHumlI1xorsL9c0zi3+67Fl6JQHj/MhSTElU0 EIx/10OWdMXvvogInedWPisQV1ZpBbVdIEaDMoFKvkTQmJDIVtfGkX73mt6XR6sL k39rBzjEsMHyQQCfzrITs4BaZq4pOmwG7TLMyPVzZSyaMrKf7WXesSmmn5i4t/yo KrtJUzfe7xetZfprcoqs4i1Dulfl6z9rv7JcmEp045LwuqK3QH8/ADWdJzjPQsxw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduvddrudegfedgieelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucfrrghr rghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlh hushhtvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id 4D156D6005A; Wed, 21 Aug 2019 09:44:42 -0400 (EDT) Date: Wed, 21 Aug 2019 22:44:34 +0900 From: Michael Paquier To: Keith Fiske Cc: "Efrain J. Berdecia" , David Rowley , Amit Langote , PostgreSQL mailing lists Subject: Re: BUG #15954: Unable to alter partitioned table to set logged Message-ID: <20190821134434.GA9383@paquier.xyz> References: <15954-b61523bed4b110c4@postgresql.org> <20190814024822.GC14446@paquier.xyz> <1703025078.5205270.1565786782053@mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="BXVAT5kNtrzKuDFl" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --BXVAT5kNtrzKuDFl Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Aug 21, 2019 at 09:24:38AM -0400, Keith Fiske wrote: > As the others have stated, I think we just need to get some sort of > consistent method of handling this. Currently running an ALTER TABLE on the > parent to change the UNLOGGED state simply does nothing which is not > intuitive whatsoever. Even if it's just throwing an error saying you cannot > change this property, that would be better until a more thorough solution > can be implemented in the future. One problem with an error is that it may break existing application code :( -- Michael --BXVAT5kNtrzKuDFl Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl1dSsIACgkQnvQgOdby QH2xcQ/+JKLD++dUQwUnAr3cL9n6MrBadL6LqsQwNE1M1OXtkwW6EhxkQpgGjwuq YoUgggEN8XtDXGnfhtL21P6hXwXPHJdnbHKyuh+I5KX3EnTA0yLhDJkA2uCEKi8B RvZ8XjQgx5EBJ/JHWZhabyP8bz3iBHCUhIKAJAurn7ztBOhe6YiC0q9qLeNet0bD 1KiVtX7fvJtzB3i8zZ2lpLgqBBmME1ghetXae2os6kmwd8Po8/L3OoKH8Q2VvQtZ sk22gm8h1wu4a7Vb5Yz/WlKWCt58cM/SQRTaClIgcUQXGnLzHWDoF1Aje1PTWpZ9 m87+6qS4xz9vPJjO4Uzt2lGuo+alFgmIdevehmX83IHhCfjcI6hGlvN+ndXf+fgP TLGV2d1MajwZtQueKlFnr4dsbomEDqRpCapZuVc2TZy87GrHVBPxpPS5qe+cae8M ZCvjtJC+CBD5G5SxFRMQEbiq+Dnzdl7gfSFDljxx9PTO0/GnzLGH4g2TZObFmclR 2i3WU5DGhN+x6IJMw66wcmj0tuUj55uxChn5oGY02vPIayVUlqv1vHUM/Psblbgk oQYim1EH6TvK1IzK0BaUpzUFTtXp7qkEgF5/gvO3/lYdXASPYhvNh9q8ZAnEwh+L iqBbNaglgdCf6G1lO2MTFco1CHhNpOPFGuEQiBhp7ZTcTgxdFqw= =hoU+ -----END PGP SIGNATURE----- --BXVAT5kNtrzKuDFl--