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 1iVSBG-0005ET-PY for pgsql-bugs@arkaria.postgresql.org; Fri, 15 Nov 2019 03:21:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iVSBE-0000yK-JF for pgsql-bugs@arkaria.postgresql.org; Fri, 15 Nov 2019 03:21:52 +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 1iVSBE-0000xw-B9 for pgsql-bugs@lists.postgresql.org; Fri, 15 Nov 2019 03:21:52 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iVSBB-0002Xp-Of for pgsql-bugs@lists.postgresql.org; Fri, 15 Nov 2019 03:21:51 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id 6D1FA40F; Thu, 14 Nov 2019 22:21:47 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Thu, 14 Nov 2019 22:21:47 -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=922XefUwNIDs2oI+bDCWlLOjZ00 Y+OD12bdTeYRh97U=; b=Ofa+6CLk7aEambx/KjdJOlf1tA9+uwpTSC5HHCJDbnT Be4wqGMjVAbp7nQi80Ejv+TEDf0qTSo1l+impzEq1j7fgK6Fv77k/G7JJ02W0cGE jRBemaqJ7vyAXDlCSWW8uhsL4zQbVgATBw0px2pd2LDiMPx6a3dd21fi1P82lfLo j7Lh9AgpUk5niblNL29HvDqAPpwJYyI9LcBhWRj0cNQwFb7yhcYFdVSJ/Va5QGun FVx59Ti8N1vqpuxDwwTSURXyFcW8fQ0AeSdt1nTnBH4XrpSKf7uEkiduN6755UlM GF630fXUHu3c6kB73vLQK4MQ7D6KrunEupnTkQfde3g== 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=922Xef UwNIDs2oI+bDCWlLOjZ00Y+OD12bdTeYRh97U=; b=gdu3mbjvy97ODbSp1Ys+OW UTTxYszPR9loptxiIG1R59FXWpydp2GgLgRfE6iICFRLKn0clL4P4xfLFteoJVbs YUlmlw66+ShJg2rggNiFQl0GPZwcP21QkAy0QVNv+jSdgYFiR4rRWzSgOBFw88Q2 fCJLowrs36LWgWOIESD+8r89uKg5WXbQ5II9Yrm+QXglSAamTNFSQm5C2GhVPXT2 u81oLCNUVBKz42gYKzKlug/0tyq9jjODxX/mchLsx2w68OL0c1hl18Kfj086u8IA cLUOtDZ+0IERqNRteCaHYLuv//0eMlHz+fANMLFp7Oy3f/G3+7QQjl51USiRhGHQ == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrudefgedgheejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucfkphepuddukedrvdeguddrvdegledrkedvnecurfgrrhgr mhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluh hsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (mp76f1f952.ap.nuro.jp [118.241.249.82]) by mail.messagingengine.com (Postfix) with ESMTPA id B562E306005B; Thu, 14 Nov 2019 22:21:44 -0500 (EST) Date: Fri, 15 Nov 2019 12:21:41 +0900 From: Michael Paquier To: Andres Freund Cc: Tom Lane , Manuel Rigger , PostgreSQL mailing lists Subject: Re: REINDEX CONCURRENTLY unexpectedly fails Message-ID: <20191115032141.GH1849@paquier.xyz> References: <20191113154837.mgz2rnl6d7k6tas7@alap3.anarazel.de> <12383.1573660748@sss.pgh.pa.us> <20191113163851.e2enkdpvd3nrobst@alap3.anarazel.de> <19198.1573663534@sss.pgh.pa.us> <20191114080855.GG1910@paquier.xyz> <3808.1573754033@sss.pgh.pa.us> <20191115024512.GE1849@paquier.xyz> <20191115025412.p3beiflrd6bx6wgf@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="jRdC2OsRnuV8iIl8" Content-Disposition: inline In-Reply-To: <20191115025412.p3beiflrd6bx6wgf@alap3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --jRdC2OsRnuV8iIl8 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Nov 14, 2019 at 06:54:12PM -0800, Andres Freund wrote: > I think it'd be really user hostile if ReindexMultipleTables() suddenly > started to error out if there were any temp tables. That clearly can't > be an option. Okay. > Did you actually read the sub-thread before replying? That's literally > what we are discussing: Oh, sorry. I got confused with the thread as I was not quite clear if you were referring to work on temp tables only for the ones with on-commit actions or all of them. It makes sense to do so for all, as you said. -- Michael --jRdC2OsRnuV8iIl8 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3OGcUACgkQnvQgOdby QH3xqQ//RESJgCg4C667mum/a7F/5EGsFp60ign9gfFoaQVbiExIFQ+sHfHmoMl/ wsdp22ELlA23xfjAbnMyQx9VmR7Oijm2H3SZV+EniGBgM9Mtn6Igzf7SmPT/qF2r iVfpLSnsV6sFIiOxp7M6odUhcPc0atbUsNUfjxY3gaOC0alAN7sUBdv7g0RRuC3s V+JXQWSKJvmDGbOeUylqGHhozFmPNmuzqxFFv1QekITWxXB6ycKavlEIxnJRNQPY fQPSsry4j+SCD6p3+Bd5ZWFTP30oAyfF18HmtpHvl0KxI8mff/CTxwlvODkf4h0O /RGL/2JvjkZvsNvecEV42PH3nZ80+ObHmL0947lRl7IOvNy8jMx5DuI7bOk7r/Cp h2kE7/APUfR4AhCdyecyIhtnGmfnwDm/xFnGDXqXyLS9EjUVg2wKPpYfnBWlJ8wV KyJ/FQO8k9cg209U3vhqnIU9FRCw9nMzEpLVQ4M+vuKJzC/KoAnU9lbyib1NudoX 7RojrY/t+PM5nOhxpIWnqXFyQlSVt3Ln44MoD3NQ0Sd/w1Srl0tTg87Qhx+76jys jPW86fun3ZH7qukbE2tziaidzg0iLbAKlBb92/EXpdalJf0lqSH3KE9DbsAPOkEM sSMAdUzt0bD4m1MB8TUk4Ft2ucKDyX+bn4KakGC5xkf7HSlo2hw= =eXjW -----END PGP SIGNATURE----- --jRdC2OsRnuV8iIl8--