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 1gmYbl-0007tk-BK for pgsql-admin@arkaria.postgresql.org; Thu, 24 Jan 2019 06:35:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmYbk-0004PR-2D for pgsql-admin@arkaria.postgresql.org; Thu, 24 Jan 2019 06:35:24 +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 1gmYbj-0004PK-Lp for pgsql-admin@lists.postgresql.org; Thu, 24 Jan 2019 06:35:23 +0000 Received: from shopzeus.com ([87.229.70.149]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gmYbg-0002qe-Hi for pgsql-admin@postgresql.org; Thu, 24 Jan 2019 06:35:22 +0000 Received: from [127.127.127.127] (localhost [127.127.127.127]) (Authenticated sender: gandalf) by shopzeus.com (Postfix) with ESMTPSA id 3088F889CE51 for ; Thu, 24 Jan 2019 01:35:18 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=shopzeus.com; s=shopzeus_com; t=1548311718; bh=ml9KK3nznSF0+jTcr/d8ma4Z3hnOqI91xphzm76Gsww=; h=To:From:Subject:Date:From; b=TXMdblvzAPjF9QzszMGJLPjBnQHP9zYhzlKpqtK4bRyxnC31SPm2Gbk+kh0oZwN3i nI1qwg9pcLrOEiZteFyL79N5VefRA82z9Fiyd7o+bhO8xjw5xE5bQJIwI0uxK8Lcnm ejNKSkdCJF2IZ+qIi2It7ZLOe1kOB0a/14mLALBgoH3ZlBTh48MWHP82oDbGwW+gzm 8ebxP/o0ele+k+RdcziOR0DpqjMIuHbUFYbx+4jL7k4qDJWfDS4QeZd5ggZm/n/v0v o6GMyeaX0nqehVeF2IytgzkfxzuFGmMsicuvL+SOtHjmccb9hR6oTWkzsJMYWkkMvk T6Kuikqj11XRg== To: pgsql-admin@postgresql.org From: =?UTF-8?Q?Nagy_L=c3=a1szl=c3=b3_Zsolt?= Subject: constraint deferred but fails? 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: <7db1a61c-1f0e-d233-0756-b7eecf2f420d@shopzeus.com> Date: Thu, 24 Jan 2019 07:35:17 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello, I have deferred the only fk constraint to this table inside a transaction, but I still cannot delete rows from it. How is that possible? master=> ALTER TABLE doc.display_mode disable trigger user; ALTER TABLE master=> BEGIN; BEGIN master=> SET CONSTRAINTS doc.fk_book_display_mode_id DEFERRED; SET CONSTRAINTS master=> DELETE FROM doc.display_mode; ERROR:  update or delete on table "display_mode" violates foreign key constraint "fk_book_display_mode_id" on table "book" DETAIL:  Key (id)=(1) is still referenced from table "book". master=>