Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g3Ehc-0005Cx-86 for pgsql-docs@arkaria.postgresql.org; Fri, 21 Sep 2018 06:14:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g3Eha-0001Wd-0h for pgsql-docs@arkaria.postgresql.org; Fri, 21 Sep 2018 06:14:06 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1g3EhZ-0001WV-7H for pgsql-docs@lists.postgresql.org; Fri, 21 Sep 2018 06:14:05 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g3EhS-0002f8-DE for pgsql-docs@lists.postgresql.org; Fri, 21 Sep 2018 06:14:04 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 05D3821D2C; Fri, 21 Sep 2018 02:13:57 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 21 Sep 2018 02:13:57 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=ied1294SEfQ+uOaCTxJoPodpy0nzv21keEgtfVDQkPM=; b=nvQ1ramR Dq8qw9zkTiY1vGTuM8FCw66guv5qdrhsR5RznKYtDjlbSZflIj2u2oXaJPtUBY9A XF67blI4DKr2n164nuB2N+CJ2YF6a0G7M8VfQOg/wNOL3eCVN3bV4+lBVAJyGy+9 O7Nbs/lciLslB4kkdg4AXGv04u0aGHlYX94liPpl0o+9AcIwOyjZ7mwQDSUUKRx1 XM9fCUFB/eR0pUEStoIAr+goPMPiBxhG9TEzyVWKt2Gn6NEV+3Eyl2Jh67tjotYo 5C8NJaK0Y7vzVpVknYMUxIX5RbKhOTozG40GGa13V37p1fJNvPWYwGQdgk45m6yt yurwnMJRR4mvlg== 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-sender :x-me-sender:x-sasl-enc; s=fm3; bh=ied1294SEfQ+uOaCTxJoPodpy0nzv 21keEgtfVDQkPM=; b=NLn9FcWcjQnPpmSPcYcex0gkOYnzdV6tG5ZvyQef+3Twi tANtH+rhE/qOFuL8O85SgQuQ4KM+5ppSopWTO/TGObcrrXOGABlE+XIm6p9MFJ0N JvunfmKQnID5LL5UWWFfX4MRylZEWru+Juh9WSQyrMNcGTYRV/qjtREizhJjSYay JealKzW/xWUlJTcFh/bLGwk//DRB3TbdhASZUXaASWWM0EDqSeROEP0hKZTPRPZ+ PmSthn7pc2eHkF/gAMooUw7RWMDfiYIMCVF7iAcHS7DIVeJACnMo69+Y8I9XwBTY r8Flmd6IFwGfHhixmOzZB4LqwiaJoccYieWLg13LA== X-ME-Proxy: X-ME-Sender: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id 2A767E4121; Fri, 21 Sep 2018 02:13:54 -0400 (EDT) Date: Fri, 21 Sep 2018 15:13:52 +0900 From: Michael Paquier To: Adrien Nayrat Cc: pgsql-docs@lists.postgresql.org Subject: Re: Mention FK creation take ShareRowExclusiveLock on referenced table Message-ID: <20180921061352.GA27106@paquier.xyz> References: <20180919025302.GF1650@paquier.xyz> <068af352-1ef4-77ee-4f56-3e24a1181fbd@anayrat.info> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="liOOAslEiF7prFVr" Content-Disposition: inline In-Reply-To: <068af352-1ef4-77ee-4f56-3e24a1181fbd@anayrat.info> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --liOOAslEiF7prFVr Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Sep 20, 2018 at 08:23:45AM +0200, Adrien Nayrat wrote: > Yes, here is the patch. Thanks Adrien. I have reworded a bit the thing, fixed a typo, and pushed down to v11 where this applied without conflicts. -- Michael --liOOAslEiF7prFVr Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlukjCAACgkQnvQgOdby QH3CWQ/+Lbh5u7TPAtBAWYEjaL0qZnB+8K3ysj3YTMDDEPsrK5Z1AGFjHJdjTEPV hXCpvZjLSjwprK98ZbgQdafjMCDb1fS/zCkX+jGVj/72jbY/lif5EVXr8gU2Sbva qkBFz2jlONw6al+Q/Z1jujZQMMAshFs3Be5dEcucHfUeXFUT3nYXlupSGLKALqXl Rf/n3eCXwLoK8nQP423xynX/kD8ut3GN9uaazL68xjKzCRyG9NAnXzvSi5ofo7zE 0JUsPVGwtiUHS0M3HwqOCV9db2AkRdbvmyM7b84jQzIM7dgRWsoLkaBSby9WaWtE 8/fewUr1myZiCdWLomXcK19xZwLs6umYMXltV7ZJYTzECIEGjBGU+jla0YlUu1df Hh5dpkdYZbH7rT0Qm3lZRHEszSp3yjP/x1/enl6fWI7zlnDpH+LVI99Z+phJnOp9 46a5gukHE6e6vHh/iV3/sVNBoaEY3cmB3pmwANc+qBq4nOqUKipKqzeaPtglXaZo qhUlqwQo8rNxud+XtKVFVUHyiYsFFM80Th5pv8HG80cadxl67oo7uKltMbSL57M9 kLPQcxmHa9ezXWbqN5X2080Vo4Q6T4Yximw7zb6ZRpTalwf3aEudQ8BivBs2wwCw 23AtpG0zaBO7P6io4/ZHHJp2dQWo44wa8hhMI6EZY4XctTcVxG4= =/DQT -----END PGP SIGNATURE----- --liOOAslEiF7prFVr--