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 1ijxHa-000739-S6 for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Dec 2019 03:24:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ijxHZ-00038u-4M for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Dec 2019 03:24:21 +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 1ijxHY-00038n-I1 for pgsql-hackers@lists.postgresql.org; Wed, 25 Dec 2019 03:24:20 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ijxHU-0001fg-V8 for pgsql-hackers@lists.postgresql.org; Wed, 25 Dec 2019 03:24:19 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id EB2A921ADD; Tue, 24 Dec 2019 22:24:14 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Tue, 24 Dec 2019 22:24:14 -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=m9kMNI3GvAIFLUwAEGjcTe51p40 UvoeRpnSDLuN5fHo=; b=CWRBAMRAweamjdSOgOkn90OduocGijeA2QnXOZTCm9y 7sQW79nEnuC3TyKpnHR5Za7YqBtl5LNeJPXk7B/F+6NNgHAueViIJDUM0oBxE/vs YswxmCUZaskoqc03pjOh37XiRZQoyGcR6++wVtSyDe6PuX8Cz/NAm4M/UfCn/LL7 l+fV7j+Nr7d5uFn3TmWle+PMrCe/7HADJfaqdVceN9LHI1OLZ0YL6cgBkFJSOui5 Rpvb+CU89fw9szL9BjfJixc4vvdQshulttJgWOMsMgl2Dp/RA1TizAmJgN/AsFZF bd4kRd+FUhTvOEKiwcOPZ8yWHRRdVeDuN28dRTwDBTQ== 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=m9kMNI 3GvAIFLUwAEGjcTe51p40UvoeRpnSDLuN5fHo=; b=LCpCRVPRXc/oPnYuBswE1y tJ1toDtuWWhBNYi++TAXE1fPNe15VMXJAse48+YnsM29SzXk0zCVWvIAU3tGCY5S suk3HmxIV9pAmVDHI4P04U54j4l+Fmdq50fC++fI+UCp/Zg7G8rdXMhsbFtcLovG iUbPNYN3gGynJzBFHslCv5SnA7yKvtVL0nWNDNWsEwsGNENd/bmEPtsHUO0X1VNZ VcgwOnXPGNYuMql2lvaXMnX61zSt7bl8C1M+lPhhOO/2kYd8j3O92VBkczx7PLMU FvLIJC85UdlF/PreXcx8VYVji8w485ztn0/pBa4Ue1AMRTMcnupsjtia9bzMGkiA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrvddvfedgudduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitghhrggvlhcurfgrqhhu ihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucfkphepudduuddrud dtvddrudektddrudekheenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhes phgrqhhuihgvrhdrgiihiienucevlhhushhtvghrufhiiigvpedt 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 64D303060802; Tue, 24 Dec 2019 22:24:13 -0500 (EST) Date: Wed, 25 Dec 2019 12:24:10 +0900 From: Michael Paquier To: Kyotaro Horiguchi Cc: mahi6run@gmail.com, pgsql-hackers@lists.postgresql.org 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: <20191225032410.GG3448@paquier.xyz> References: <20191225022203.GD3448@paquier.xyz> <20191225.121826.1424647210525092235.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="4C6bbPZ6c/S1npyF" Content-Disposition: inline In-Reply-To: <20191225.121826.1424647210525092235.horikyota.ntt@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --4C6bbPZ6c/S1npyF Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Dec 25, 2019 at 12:18:26PM +0900, Kyotaro Horiguchi wrote: > Still the owner can drop temporary namespace on another session or > pg_toast_temp_x of the current session. Arf. Yes, this had better be isAnyTempNamespace() so as we complain about all of them. -- Michael --4C6bbPZ6c/S1npyF Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl4C1loACgkQnvQgOdby QH3rng//QKfM2H4vvxIAOxlwcEK+BWRJCLBpxWkEol/OJlDpVzU64WcNEpOGBwN1 /RzKTl6XF0EhaggLBbUod2OVTo7fJfLyGTkgvZv4FlTt131hQ/hFRqQF49NKxkWY g7+/NRS+ke8VGKk7zGmYx69eWe+3Tv9Wasgg+BsTLJ7kH87AGqk9sINHeLxtCJx/ thk1Vh1VSc4zh1OZ4z5IxJ5hsjgyWp35Lbv5xppbHcXrt6T/nRNVDyQm2T8HvH4v HdD8CZ4Q8QjcLKonbV6yCckl2HBJgD071z4Hn+agQG+IdOmPoIFl/OO9J1NFqjuT MfHpparrQaZQqw3ISUVmt4n2s5/Kr5lIiY2C3t/7Qy7TlWWLsRf+rfL/sEVvweCo E9tvq/60lNUzykq1e7IgBYlGBBQ2zYUsHSrbjmr5WtTeU/n0QbHcRi90NO916EHh QIErXXoAmpzph4QPNpybqkQO1ShjQNiXajyvBKpsHShVZu5RbEuK1qegoLktIjSw OUhEgNt6wmi10JAhLEdTtr9ApQ0IVoZwBTtanCnN5XPkSM7+XsRus2kYBCUlnAzc iRIi/skYNCP5yIdbhZNSR277ZHfMNJnQayP+XEP8/PYQJ8hkfmSb/yFEnIhdHM2x rcVVVDlclji8pBDnT5693975kd8PSW6o8X0eHaf3OBuMVb8nPx0= =UT3j -----END PGP SIGNATURE----- --4C6bbPZ6c/S1npyF--