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 1iklZb-0003Jh-85 for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Dec 2019 09:06:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iklZa-0000j8-28 for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Dec 2019 09:06:18 +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 1iklZY-0000er-7r for pgsql-hackers@lists.postgresql.org; Fri, 27 Dec 2019 09:06:17 +0000 Received: from wout3-smtp.messagingengine.com ([64.147.123.19]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iklZU-0000ec-47 for pgsql-hackers@lists.postgresql.org; Fri, 27 Dec 2019 09:06:15 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 7AB9458A; Fri, 27 Dec 2019 04:06:09 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 27 Dec 2019 04:06:09 -0500 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=fm3; bh=IM1KHkBuLHwFSVjjt8J96gIaKtZ UIWQf5VlspDJRUsQ=; b=WfRSci6MLg5fa1bUnIcvl9b6u0+sAmsv0tuJiwM916m AWGo1clIMB1sXFcZAj4vKX69IU7t+eetVIHjL6r66qwRaexMZ3uYRthiRIMBNeDy uBHy7gh9Kj23sRT+X4hrkwWIU/Ta2Y6SYKuQdm07uFpODlqrzwsfxRQWmrwd7N7Q JR32/lg9IUKOglMrcK3LgWvg7Hc051Waqj8212waDycq/NyUPGvMJJu1XbRTDaav Umr9R2r8Z6hv1HCFJ4xI7y1Dio3LF7Z1zT4G35tE7+wLlZ1GClNirRQeX/mn6BUS odFfUNnfeAXjvuXd/1eWzLSkCxr9BMR+tevoCcgwCZg== 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=fm1; bh=IM1KHk BuLHwFSVjjt8J96gIaKtZUIWQf5VlspDJRUsQ=; b=ELHjrTlAEmkZifPvaXM3OW Zauv4rBMXtDTiYlOYhQ+3+6dnCGl/Mi9ISHaUk/xPt5198W9O5P+Ktd/blEJ+e1h X/ValaKBn1XnbiSPhF2kYnDMdvJKQXbiNzH6OHZSL+qA/RL2bYIHp4gznZ+17tz9 rs9oZVPti15/Yd8oXTPVkCi82+qHWsWzJUK0CmrSF5whYQpTnbOdzCirCoiF3YMA nKLDVpJIExhiuHKI2nLPP5H0HHSaeuitHZ4QDA+ECKWuRnuyhxBS0XJHQV6oRz5u a+dkH9eq83T4lgO9baveOwfvcmHkFVcY8+OSu7soyhj7uVEsHJJJX125Wm8S9tyQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrvddvjedguddviecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enfghrlhcuvffnffculdefhedmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecukfhppeduuddurddutddvrddukedtrddukeehnecurfgr rhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiinecuve hluhhsthgvrhfuihiivgeptd 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 7743B8005A; Fri, 27 Dec 2019 04:06:07 -0500 (EST) Date: Fri, 27 Dec 2019 18:06:04 +0900 From: Michael Paquier To: Mahendra Singh Cc: Tom Lane , Kyotaro Horiguchi , PostgreSQL Hackers Subject: Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Message-ID: <20191227090604.GA540891@paquier.xyz> References: <20191225022203.GD3448@paquier.xyz> <20191225.121826.1424647210525092235.horikyota.ntt@gmail.com> <20191225032410.GG3448@paquier.xyz> <20191226135329.GA249363@paquier.xyz> <28862.1577382716@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="SLDf9lqlvOQaIe6s" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --SLDf9lqlvOQaIe6s Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Dec 27, 2019 at 12:33:03AM +0530, Mahendra Singh wrote: > On Thu, 26 Dec 2019 at 23:21, Tom Lane wrote: >> No, we can't, because the particular temp namespace used by a given >> session isn't stable. And I'd prefer keep the name of the namespace in the error message, because the information is helpful. >>> I thought that auto_vacuum wlll drop all >>> the temp table schema but it is not drooping. >> >> Generally speaking, once a particular pg_temp_N schema exists it's >> never dropped, just recycled for use by subsequent sessions. >=20 > Okay. Understood. Thanks for clarification. Please see RemoveTempRelations() for the details, which uses PERFORM_DELETION_SKIP_ORIGINAL to avoid a drop of the temp schema, and just work on all the objects the schema includes. And committed down to 9.4. We use much more "temporary schema" in error messages actually, so I have switched to that. -- Michael --SLDf9lqlvOQaIe6s Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl4FyXwACgkQnvQgOdby QH0q1w//R7w+a3kApHiwf3fEWVN/ZegmK68U3SD6E3LnPuIx2GkH1KpSm0VrzfKS mVNEZ3uUPWC66gu+t8SgDEjJzWHQOAv3zjYOjekiQKGcteS8xKaltePFxe0bF/Q3 IPWd9DZpK1UeMtr/pi9al3fLvfph9TpQ3aXyg6HUNoqAUKFrGr1BZvhcS6LRVL1G Xl38Bjzg1tad3uWZufmhVN/wH3ecz+r32VOFA3rWDTvu5gkSzlwu/hhl/L8PDA+x 9ZMPLqX7FJgenBoQiYV2tn/FZqF3czCDk93AoR7M0vh4TSCSnG2VKEeRwlxua4jn PjsdgvBjzaGEf30DeoI6771G7bjYnv9uEwNp3kTNE1UA1LRgO3IpHOCm39sOThu5 kZHJ+xSExwmXVp/gPYWqO5eHKXTb64f8741WOxztTHem/vzFEeO+3sTC/qmZNYbW Snsw4JdTu3pfSHAOeRH3uobo/5+JLKvdWnNDblsY9OeXm+sYbm6q62hIdDH+pGB0 rWzt9osCJvA3LPJx2zie+tq3LNwoAY3gKWAAwzOU5VKEM0mVYbGwJgKMRO2M+Dd5 Cz4uc6evHF9X9TI0WDAqnX5ZI3GAE4T81CEfpYhQ72DurpJEggI4d72mbVFBAUmx vXQ9VbYeQ4+tuAG7Q7gdf3UsYJRG6PN4+o6Eu+bdSfLGT4e9BHA= =645h -----END PGP SIGNATURE----- --SLDf9lqlvOQaIe6s--