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 1lc8l5-0005zQ-5l for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Apr 2021 15:39:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lc8l4-0001sg-2y for pgsql-hackers@arkaria.postgresql.org; Thu, 29 Apr 2021 15:39:18 +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 1lc8l3-0001sZ-SL for pgsql-hackers@lists.postgresql.org; Thu, 29 Apr 2021 15:39:17 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lc8l1-0002Tb-Vc for pgsql-hackers@postgresql.org; Thu, 29 Apr 2021 15:39:16 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 30C955C014E; Thu, 29 Apr 2021 11:39:15 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Thu, 29 Apr 2021 11:39:15 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=qCoMmioJNDmgxZoxcF4CQANvf1WESR0yfnJ2T4TiEKU=; b=BiVVECjw wAG/1GNV+fi2v70TfRLg1XEY1uKWKpscSD7Ua37FcPOy+xeibIRj5CjNPJW/4Nuf Y8HLWsBod8I7IFdBGivWHXVCA/VfdLFpo4e7Suq0uy7FvL3YbkXwQ8lQ5/fRZvoD mNcnOl57lMx0W6tYd7fPfpymcRczz+XE1ZhRi9fRKz4awPbe9s4ncDJPn9rWg0lo +Ex5bY5fJCbqto7LxmNbXgT/uVlnzPR2/PAjjvVpCBAD5GzkIXKlo4oecQsBjpke 83VdCyeL0RCZIOCSOVto7YS4+j7swwcn9d9heUes6qjvbnI899tMmMOIKL48Swfx EWqJKtjR6p0BGQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrvddvgedgleefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfggtggugfgjfgesthekredttderudenucfhrhhomheptehlvhgr rhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh eqnecuggftrfgrthhtvghrnhepueffhfejieeuueffgedvudekgeeltdeviedvieeufeei ieevgfetheeufeethedvnecukfhppeduledtrdelhedrudelrdelheenucevlhhushhtvg hrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvgesrghl vhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Received: from perhan.alvh.no-ip.org (unknown [190.95.19.95]) by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 29 Apr 2021 11:39:14 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id D70762A0ADE; Thu, 29 Apr 2021 11:39:11 -0400 (-04) Date: Thu, 29 Apr 2021 11:39:11 -0400 From: Alvaro Herrera To: Justin Pryzby Cc: pgsql-hackers Subject: Re: default_tablespace doc and partitioned rels Message-ID: <20210429153911.GA28562@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20210416210201.GK3315@telsasoft.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2021-Apr-16, Justin Pryzby wrote: > If this parameter is set when a partitioned table is created, the partitioned > table's tablespace will be set to the given tablespace, and which will be the > default tablespace for partitions create in the future, even if > default_tablespace itself has since been changed. Pushed with very similar wording: + + If this parameter is set to a value other than the empty string + when a partitioned table is created, the partitioned table's + tablespace will be set to that value, which will be used as + the default tablespace for partitions created in the future, + even if default_tablespace has changed since then. + I made it a separate paragraph at the end, because I noticed that I had added the note in an inappropriate place in the earlier commit; the second paragraph in particular is more general than this one. Also looking at that one I realized that we need to talk about the value being "not the empty string". I hope it's clear enough now, but if you or anybody have further suggestion on improving this, I'm listening. Thanks -- Álvaro Herrera Valdivia, Chile "If you have nothing to say, maybe you need just the right tool to help you not say it." (New York Times, about Microsoft PowerPoint)