Subject: Re: constraint deferred but fails?
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
References: <7db1a61c-1f0e-d233-0756-b7eecf2f420d@shopzeus.com>
 <CAKFQuwYSELmpEHtaywi3v0Msx6UphX8ygjr0OL5OLc8vXbBZdA@mail.gmail.com>
From: =?UTF-8?Q?Nagy_L=c3=a1szl=c3=b3_Zsolt?= <gandalf@shopzeus.com>
Openpgp: preference=signencrypt
Autocrypt: addr=gandalf@shopzeus.com; prefer-encrypt=mutual; keydata=
 xsFNBFYDrhgBEADgy4VcUP5RL8bNoUL7iXjiapJ/T7Tr3IKEI6VGUwXD7AEX7qwCDEYKoQdA
 55g9RqTyb0C2h07vDeiQWiiV1fkZznVMuBWt7sBez2FgVlw7B+VpSArYGDm2LelMIxMk3tiZ
 r3U7pGA8WLk2Yxk3x3vhVnmNz6h5aMeRv4cj9xRM/hEVlxk8gleamAzp9V0EIY8S5HU8R0Ii
 BGev96trV/FjStxhLmv41NUv8RMaq+z32G2FmTvuCTA+BVd3Yom4riUF29yW986uLcyBWKXz
 tnwX65GE8Wskzt84SiHOr3fwApbfq5QURnFTMI1yFjYxpyP6f4quyvJI68psnEaTxo4FRB1F
 lIPqsqKRlPb/PaNNnJ0A3ofDGklzMKPKols7srqWxggoojqJDzeBbd8GVKCTZjVFndqlu1WS
 76w1XHUi00vAPbMHwaiheTT8frQD9nYPlz5D9TOzjwEy7LwsQ6nXr/8AHju23CgcKiZu7TTQ
 BVW0JkPW20/Ms7PgGUCLRTNzqZhdQyyXPZmW4LJVPLAnD0RhPyQ0+PpL8lpZITM3i6Q+YorS
 /MDo7Gcm3KJTx8AClt0KmWWJ368VCu2JaLNYYrahXcz7j2Pbj7tb5jMzlYHdO9zeqoelorrO
 7kUeSfQyF69J0UPdCB1Sh5y1O1JQxj7rJvsxHMJ/LqbdU3nLmwARAQABzSpOYWd5IEzDoXN6
 bMOzIFpzb2x0IDxnYW5kYWxmQHNob3B6ZXVzLmNvbT7CwZ4EEwEIAEgCGyMCHgECF4ACGQEK
 CwkNCAwHCwoDAgcVCgkICwIDBRYCAwEAFiEE8G1uorx41rmUMVV+pF7NfL7weDwFAlueBmwF
 CQd7i9QACgkQpF7NfL7weDzHthAAxTirX7fEq8kGf1yjmsW4nqBIbtHa8k6gbnwMDvp0vH3r
 hp4pH+xE9FyI2LnbroLbdIjSamjSwCMsYc+mUW8d1M69ccNZzpRqLpEVx9cAum/XSXL5g6lZ
 /qeWInPOMhAPNzeYm7GWexwqHtAOeURlVVd+m2sRj0d+OFT5s+OparyIMNnPxrUZYTjscAaM
 Ls5+4ficGYdTGCUjOHsN6Gv7kxjKtoWpenjyBHqeOZ+O8B6UfVrg9tiM9kQiwLf1j56RBffq
 iU31x9PmTgUw4xFBF2jhUzbrDz55F9rhRtIJZhHm6vwkTb5bM9XGuoXETuskvNU8L6Dwr4gf
 vKx+099nQu4YGkuYJvhFe7wyO0HKjQSr5rN7iG39bIyct0qAk6YzobeLyzwtz2/v2avkibZr
 TxqDeFUhCxkXqagYSKgMAs8o9q9wcSwlvXVS6fIvePB4gzmygr6JtsXALR6HBHWo136AHAVU
 3pvwrC+xS2JDM6dz/xeNmF+1ss83O1MIs6p5Fc7oBpZekUMwC7Y2uUsxji7i9URQqj/cPFsW
 BF7bdiXb7IHmpU5pZo+ul+rVjPWh568WMW0VA3U4idBSngBwb1EEm/LaFG6D90NJuJa1KVF/
 7Ewgilj5PmOST7nn74WfHSQ4HLa1+XOH6JMAozqCLwYFDgX4g5HffgXyGFDdw+POwU0EVgOu
 GAEQALm6DmJK6K8bvy3oQQBnNGDBhN0uaCqIlD4nCT0Fm6RXEDSZ1PYVkbJjrw/ElI3J073e
 vkHykDPzPpSP1p5BDqzXUk3JQsJdixaOouAt6WQDKs8xy2bnkkj8y77+kCp1T2i7NGLaQ/GN
 HPd6Gf8BToYHdpNHK+4tqurAxIB93JIK36AbZ9ZMwyha2ytCEnSpED7wgPIcH1+bEprfvQC/
 l2S+Gi1YVOB84Qebxe8/qSd/FHQbHuEFd/CcWoxCMvf7amoyHKyWJNEUhjMlCgQAhwlEVzhr
 aBjpqV1iatZrOBxSJnK6C3ZXm5H/rMYsXAyQ8hgVQlayVXUCa1Ea3LsFBcts+y0F36IRlSlU
 UrRBcdBpIsM45bKvK7OP5c8ovEJj/QXPAD7Q3SfKp78pEJCSozAMC6poC+Lmjb6ghEOlqRbn
 dLF1/zGg+JqsfdT6qW/No73+n+mExdMiLhplZu7gpCgJ2pmqQTssUBeexFDChIr0WROtSFkz
 0NP3tMcPlkSel/sXoADyWvt/pXkAXqh+FI6aj8UQV1+k+MinlrM6fRWZur4lzY1EoccR/Jq7
 r8zn5eR4ylPb3fFVDH9LKIfsi/26LICa51Deo3tL6HMJ4JFIHiFHw9dxdDeXfNyQjaOXERgF
 q9qztkAXDjGq6FwI/AJyp/DpkBY+qaKxf6XW0+9zABEBAAHCwWUEGAEIAA8CGwwFAlucw6sF
 CQd6SRMACgkQpF7NfL7weDx8qxAArm3a0P1uMcUWL0WmTcIr2MmsniPQoNeNRvZ71e7KEg+W
 vLnH1h9Xu992NjXapPvt5jMizwN4pJ3DXxy6DyRhiykCPVNrgpREPjtIiQXHESlINmZF/Zg+
 xcFTxbWYT2MxjkQXqPNe24z//AnQZpKwDj9bYJ2gG3oRcd4JPNjOWtewHtPBWcpkwZwH94AX
 OYm2MeDXxzXGB4519GNqvfsKONCoIR33ggVC1rwSZvlNzwqaJjHC8NWouhlKkzw8p320xLUP
 8HmADScNTvhFkJS0ajw0ViumSdGC4yptuUQeOlgfI9CR75l3aVromKXNOBMEH7YKEglEvjek
 yWHJYW4B327C/qeBrWlNKRFABtTfJY6zb1eeXFfwv563BRJisbM4ZzVPaDhMyWMUMO49J44W
 wKS5HAKypkCKhBxNCSV2nbvEreQZZLZh8gQCW9MiIGmhAQ10tauiSNRyOwZufBMslCb4a6FR
 uWOIWk3R4vdwi6AjeIxCiH8WDRew+ZBB1cnPlVtgaby6bf8g1Vs2PwGb5aAuV5+y5YkEOm3G
 Cps13vRxoPec6pZBJpTWTpuN9oORgb5CyYR7RpCzw0iZnX7OD8CGcHsDIWu9BXWt8SFH5y4s
 gQhjE28tukU/hlAM7rmOggpTYOme1Le5Gu11joYWmDsxkxHL7SsHJjEbYWFjRoXCwXwEGAEI
 ACYCGwwWIQTwbW6ivHjWuZQxVX6kXs18vvB4PAUCW54GbAUJB3uL1AAKCRCkXs18vvB4PE5O
 D/0a8cMqq4elF9YeyYGS4fL0ZbGU4eRxdWIqffEecMRWGsEjfJKOk1TQj2y07FRdpan8QpOY
 +n/cwDExmxMEf8kV7sCG43bstS9/4uJpCThA6KEZfBAU3MveYZY6WvU0cvgWw4SqbLOCTTp0
 7a390PzlLqZJYX+CFTjSEuIYpqzeNNLChibzlCNfSCNahBYMBb/smNttsMP1jas5U+a2d6Rb
 QsoDjmcg7F5KFU3f6VNRem5XfyTODR2/uUNGSQkQ2sD3oMpWAp+3gneJJ4mNYO1LwpN0EJmt
 0D0SwK1K7jbPxKpDTZMoD19VgPKJMst50s7VGx6QUAbdlZ7iM1d8dg1HWV1Yzl8W28mkx2/3
 L9SpszBua4ovJrOgkh1Gw3WXNm74Jkr7BPrz8WPhZkKYlkFfakN0FqIxPGG3kSUHWza3ksKF
 M8vxyfCSu4PRNW/lxKM80tLH+rIQehGw4zhdKEVBJQLuJSV/NPtQjZpR3KFUupLLCTNA4JuN
 G+vEzGC+ZzaDU+dUyP4hWip7HePpK6Bs4lEUobTEfVHDrUXMHJKg0JKlRgQzLbMVj+PADU0w
 1vbFelM85XeDwto0kBY8de+TZxpPOANMyMRkjeJufQYajOr2gDDt4RGsE0c78LJZXS+rGrpB
 WrsJqqjirA5ogzYdAlObw1aZdUR6lG94lfdDZQ==
Message-ID: <11b894e2-b357-d30a-b23a-b8389be466c2@shopzeus.com>
Date: Thu, 24 Jan 2019 07:42:18 +0100
MIME-Version: 1.0
In-Reply-To: 
 <CAKFQuwYSELmpEHtaywi3v0Msx6UphX8ygjr0OL5OLc8vXbBZdA@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------52BD26D8E7F275B227B65FA7"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------52BD26D8E7F275B227B65FA7
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

It is already deferrable:

ALTER TABLE doc.book ADD CONSTRAINT fk_book_display_mode_id FOREIGN KEY
(display_mode_id) REFERENCES doc.display_mode(id) DEFERRABLE


2019-01-24 07:39 keltezéssel, David G. Johnston írta:
> On Wednesday, January 23, 2019, Nagy László Zsolt
> <gandalf@shopzeus.com <mailto:gandalf@shopzeus.com>> wrote:
>
>     master=> SET CONSTRAINTS doc.fk_book_display_mode_id DEFERRED;
>
>
> The constraint itself has to be changed to deferrable in order for it
> to be affected by the above.
>
> David J. 
>  
>
> -- 
> This message has been scanned for viruses and
> dangerous content by *MailScanner* <http://www.mailscanner.info/>, and is
> believed to be clean. 


--------------52BD26D8E7F275B227B65FA7
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>It is already deferrable:</p>
    <p>ALTER TABLE doc.book ADD CONSTRAINT fk_book_display_mode_id
      FOREIGN KEY (display_mode_id) REFERENCES doc.display_mode(id)
      DEFERRABLE<br>
    </p>
    <br>
    <div class="moz-cite-prefix">2019-01-24 07:39 keltezéssel, David G.
      Johnston írta:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAKFQuwYSELmpEHtaywi3v0Msx6UphX8ygjr0OL5OLc8vXbBZdA@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=utf-8">
      On Wednesday, January 23, 2019, Nagy László Zsolt &lt;<a
        href="mailto:gandalf@shopzeus.com" moz-do-not-send="true">gandalf@shopzeus.com</a>&gt;
      wrote:
      <blockquote class="gmail_quote" style="margin:0 0 0
        .8ex;border-left:1px #ccc solid;padding-left:1ex">
        master=&gt; SET CONSTRAINTS doc.fk_book_display_mode_id
        DEFERRED;<br>
      </blockquote>
      <div><br>
      </div>
      <div>The constraint itself has to be changed to deferrable in
        order for it to be affected by the above.</div>
      <div><br>
      </div>
      <div>David J. </div>
      <div> </div>
      <br>
      -- <br>
      This message has been scanned for viruses and
      <br>
      dangerous content by
      <a href="http://www.mailscanner.info/" moz-do-not-send="true"><b>MailScanner</b></a>,
      and is
      <br>
      believed to be clean.
    </blockquote>
    <br>
  </body>
</html>

--------------52BD26D8E7F275B227B65FA7--