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 1iVABj-0004o4-5p for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Nov 2019 08:09:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iVABh-0006PM-Ml for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Nov 2019 08:09:09 +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 1iVABh-0006PE-Bj for pgsql-bugs@lists.postgresql.org; Thu, 14 Nov 2019 08:09:09 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iVABa-0001Aj-97 for pgsql-bugs@lists.postgresql.org; Thu, 14 Nov 2019 08:09:07 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.west.internal (Postfix) with ESMTP id CF24A662; Thu, 14 Nov 2019 03:09:00 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Thu, 14 Nov 2019 03:09:01 -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=yaUTK5t4oEzW0f85Z0bSkoY5f8x BS8zK62lwms04oKs=; b=cQJl/MzNnbQjIlO0eve8QnbPewsajL0GtdQDRBZSZKb ir/Fi/i/BiQBlepWICNfhneAtN5GmLJxMV3roWmmY15KAHjHbFMO09Jr9T7+grVE +q4O4KpepwejBZSaXIMtlcQXwe5tEOFBDE62d0TKz7joViNPVQrFkdF/6LDwaPHp AlVRiFApVC1zLb+TWLe7yDX8sfkPwtg+lnT8wMYyycxAdN/t91NZjkfqqAk+qBD8 fKuzv1zszmeE2KbTQGOXVNrn0s3qiX3vrcho7yp7fyZvVMpoQuqHPqgKJ+4nmn9D aWOsuMJuyOJ9ZmVhR2YqrFAqkci3RxRhA6sO6zjhVpg== 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=yaUTK5 t4oEzW0f85Z0bSkoY5f8xBS8zK62lwms04oKs=; b=AdveEFW7hk0BqTOtLUJl7D lI/qaLm1uhF3mQEEQHZVdkGFwktS1bQ5IJDGVuir0GOHIkDcCAOOyP04gn58h2mZ kWgPxnyBUIufmKzcTsJRcpG7eJ2Qw+FbnDEzzZzyL+zwoJRMuFNdL2I7O0I9dkpI lyHeNH1D1giua+9DjRFh43nG6SEXqzcjjyR+Dr5ko2w4PXhab3SXxTiCmy/VafU9 zniLfhsQG10w10ne+6Fqzjw9VvvrxdnYPzYTRw7VQjT5ve6JxJOy/0Frd9UpHT1N dpJStPl2XmMawQyf9NX9cpKTPLaYoQBq0+m5aCeAsXAD7uZeVeXgTtRwcT7BFePA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedufedrudefvddguddulecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enfghrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredt 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 62A3D8005C; Thu, 14 Nov 2019 03:08:58 -0500 (EST) Date: Thu, 14 Nov 2019 17:08:55 +0900 From: Michael Paquier To: Tom Lane Cc: Andres Freund , Manuel Rigger , PostgreSQL mailing lists Subject: Re: REINDEX CONCURRENTLY unexpectedly fails Message-ID: <20191114080855.GG1910@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> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="5vjQsMS/9MbKYGLq" Content-Disposition: inline In-Reply-To: <19198.1573663534@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --5vjQsMS/9MbKYGLq Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Nov 13, 2019 at 11:45:34AM -0500, Tom Lane wrote: > Oh, I like that idea. Keeps applications from having to think > about this. That's interesting, but I would be on the side of just generating an error in this case thinking about potential future features like global temporary tables, and because it could always be relaxed in the future. I am actually wondering if we don't have more problems with other utility commands which spawn multiple transactions... Any extra opinion? -- Michael --5vjQsMS/9MbKYGLq Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3NC5cACgkQnvQgOdby QH37uw//QqzxcpoZTBSHkqbUDjobhbuIMLdupR5MoKptetrfotqYMfFFp0r6YF90 lk0ajxZv88wCd0KFNNpZq8m49Jygzk+CuJn9bFItQ7k/IVxtoL/tAHgkFp0mpM9V uy0FHmB0zamhMTyTGlvhH0iwnTJRbP9VuTNbDBpOrn19igRHPL0TVnulqXjlTSj/ qJY6fTmrFseFSWem1vBhjhFmjyn4mb2iB+XK7ocokSvVFZ7z/4B2fNwx0hlZmQyP wer+L3WaH9AHBv6j0ddXkmzOkhXYaxzjrLj4pwwN3wQlNE8lkndoZgu0AbEiCY/m SESIwTcJmtMACQ4vnpNnLtgEtUtkBc/q4FVFuE/ibOormcmn5HBo+OYLu03o3D/N xcfd6g+hYofMgawZmkzpvItHMWTkdyrA1+hCRC+5jQm8BaPlZ+x4ziwTeEa36pGD uebxaxIDsoL+Q82OOH9HTowikCxpE13pop9lC8LKUXsT/0MRbJq9RdZ0LmZKvU3d YIWFWCzjNe98gRJlIPhKWMe7ELvuIEwBLjRePwL46M92bYhquEn3wtxguBQAQcTE 4Idwx9KdFpIyupgJ+qJpw4jPz41S1fQSbRkeQiIcplujGj1/4k8j1tiVT9j9GziP tqqEtQpgiJsYtDO/KGtH6jt4e/xv64ehiY70gc5w464207JvWGA= =aZRq -----END PGP SIGNATURE----- --5vjQsMS/9MbKYGLq--