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.92) (envelope-from ) id 1j7Ztu-0004C6-3F for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Feb 2020 07:17:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j7Zts-00011I-Ir for pgsql-hackers@arkaria.postgresql.org; Fri, 28 Feb 2020 07:17:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j7Zts-00011B-9m for pgsql-hackers@lists.postgresql.org; Fri, 28 Feb 2020 07:17:32 +0000 Received: from [64.147.123.25] (helo=wout2-smtp.messagingengine.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1j7Ztq-0004n6-D1 for pgsql-hackers@lists.postgresql.org; Fri, 28 Feb 2020 07:17:31 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id CC977490; Fri, 28 Feb 2020 02:17:17 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 28 Feb 2020 02:17:18 -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=fm1; bh=lC4uDO6ebmDOWZsyhY2qu0+H/6T p5jeR1JIgLqCGCKw=; b=BxnWDcdaGVTR8XTP9tnhLpuf24NbXBa0nPVGOuA+Zxs coiQqkMXkdVvie54pDg5wPTzVUHqhNPg3v7PMlMBjc/vjz8KavZGoIfO0ivV82ue qSR/oQ/p+v0JmpKxemzPq4dW3TCzF22qDOaqESaRgygwFB2q2f1Ew2uLpiehwZqn bVaGTu9JDvm7RpRIUvJrm2BpNRYVKzygOFBYqpgYr1fMdNJl+kb7T5b8PoIkZ742 fVhAJnCvirUl/f6b1/xK7zJxdM5quo5tGDGP+uk3iIKhoQEFPFMlQ0t9LF2rPKVg lsFd/fvgSLz8W2TXwHy4LIST9RO/D/ycK1421fcIFNg== 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=fm2; bh=lC4uDO 6ebmDOWZsyhY2qu0+H/6Tp5jeR1JIgLqCGCKw=; b=Qdest8Hi9DYSwFOLN1Bvcm CETsC4v6txIkgtcjGW8RDa0XNzqSfAn5dl7PcLkBrweyHKpP0KyKn4aDOQG7KWpL 4KOkg3NbuDt750xfxcvmCa2sZyFMxcXmnDKoao3dsN10zZu1q9c04V7lbSekYkst kCffdmuTNTfLUI5nUWQt/J2lIyDphpH3iLyaaRnkFCxd3qCuKtf35dnjO3zpZX/x rcws3pMBqv0l1cSDGIH8KzTslKoeEr5iDjrVsPMFiLbOwsrjSxfZKpbeYhpUTF7/ KiBhNjO0aoex8/cNknGWa8j7cJGJJAgpamn4S7iZm+QJ8E4iCphnuku5Zu14xlRw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedugedrleejgddutdejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepudduuddruddtvddrudektddrudekheenucevlhhu shhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlse hprghquhhivghrrdighiii 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 8D4A73280064; Fri, 28 Feb 2020 02:17:15 -0500 (EST) Date: Fri, 28 Feb 2020 16:17:12 +0900 From: Michael Paquier To: Mahendra Singh Thalor Cc: Tom Lane , Robert Haas , 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: <20200228071712.GC2688@paquier.xyz> References: <14868.1578420368@sss.pgh.pa.us> <20200108004409.GA3413@paquier.xyz> <5602.1578444917@sss.pgh.pa.us> <20200108015601.GB3413@paquier.xyz> <20200109040612.GG2251@paquier.xyz> <20200110080125.GA250447@paquier.xyz> <20200110110748.GD250447@paquier.xyz> <20200116040618.GF3117@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="ABTtc+pdwF7KHXCz" Content-Disposition: inline In-Reply-To: X-Host-Lookup-Failed: Reverse DNS lookup failed for 64.147.123.25 (deferred) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --ABTtc+pdwF7KHXCz Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Feb 28, 2020 at 11:29:56AM +0530, Mahendra Singh Thalor wrote: > Patch looks good to me and it is fixing the assert failure. Thanks for looking at the patch. Bringing the code to act consistently with what was done in 246a6c8 still looks like the correct direction to take, in short don't drop temp relations created without an existing temp schema and ignore them instead of creating more issues with the storage, so I'd like to apply and back-patch this stuff down to 11. First, let's wait a couple of extra days. -- Michael --ABTtc+pdwF7KHXCz Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl5YvngACgkQnvQgOdby QH2DlxAAjBcAP7GZGtCE2PY8QFGywG78IFWvrPaOAdG2uD49Ok72Cm/Cqzdqjnxs yQUhQ3I5V2ez4hTJKNCZ7EcKy9Hq8EgUwwFGiH/ITR+40ySlO1ZS3IP1BD8JRn4e u26e4iuoQZEmV0C04uMAJtQ4y/uLcGjf90Q08Xv/mryWkxnwxf22M1Boauw981Nq oDoYjHnE+OtB2YYJJAXSCHDXxrNGRs2sebDAraK8iEq+v5tRt7ppCPDQT1B04g9J aE/88khdXbsLHNC9/nOh/dwl4eaNddc0a1jdHFodY3eMyVxnqY/XZmey6XlCFSgl 0eyTW0Mwr1UswLkbbO1ZcsilfVuzvZzBOFZyEYWxoQcytEONiu7407ExQdSqijMO FG9bHjgwSz+opoIKQ5xO3XF5M3uS/xRYQF4GUHeKgsCPH4fIOtKm+G+Kx7ZaahwL u0UB/OenL6VnosrV4T2nkCFJtr7ocyNJEgqlZo8yYWMyUMz/DY6khEyE+XZuVQZz HQfla5yxEL5sLmJQwcyhui1wNlJnfg8KtoKVaOMlzkSe1OeiqHyIKTVv5ca0fIQn s7pNxBTYAdaYSwvd43aznWiMxDddtf6ENCUAom2gAWabYxyfgvBN0HPkDaPDzBnr 1vIYnOPII/A+CMzg/xDj0MAtZEH1XL39ug6e5y9AGxM3YOuhwJg= =WqSx -----END PGP SIGNATURE----- --ABTtc+pdwF7KHXCz--