Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oyFCk-0007j0-3A for pgsql-bugs@arkaria.postgresql.org; Thu, 24 Nov 2022 16:36:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oyFCi-0004qe-IH for pgsql-bugs@arkaria.postgresql.org; Thu, 24 Nov 2022 16:36:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oyEd8-00048F-0m for pgsql-bugs@lists.postgresql.org; Thu, 24 Nov 2022 15:59:14 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oyEd1-0004ev-3R for pgsql-bugs@lists.postgresql.org; Thu, 24 Nov 2022 15:59:13 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=BTaIlU1l3/1VkNby3ydqBxgQRpTbNta8/pjjiE7qcWA=; b=fHhswWQdKPLdS4IX5VFH10c58B HKmfKvnoJqyvFCxmOZOF8jDUrA2Kcn1RyRhA8Qot2GuqCTFIZBVgpJ5BMwT05iP3mXRU12ee9eheM dWPF13L0ZS8Xg/KPvyr2R3FbofRgDM4skB+c5QE3JzfYvsuHBeXVN5h5/eKeXlaqUYCJTdD6qW0Nt +1trC5YP2t8+Ab8F/et2T1AHgqx9JpHchB6c8Ngegxcb+gx04et3GeCdA5/gfIwW+p5pyU41mrxpI QQoDJ/VCINeDRMqfzrQqYNhEYd+9LzXoMrEy1aLp4AXrR5LnLMu9l1I2ePld+BR8KmBjQpOoHvYvA 27kr4bkw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oyEcz-0008WG-Ar for pgsql-bugs@lists.postgresql.org; Thu, 24 Nov 2022 15:59:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oyEcw-002FJx-B6 for pgsql-bugs@lists.postgresql.org; Thu, 24 Nov 2022 15:59:02 +0000 Content-Type: multipart/mixed; boundary="===============8876822168302147036==" MIME-Version: 1.0 Subject: BUG #17696: Creation of deferrable initially deferred constraint breaks before transaction commit To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: yzerno@gmail.com Reply-To: yzerno@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 24 Nov 2022 15:58:45 +0000 Message-ID: <17696-c1f5b5e52f3e5833@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8876822168302147036== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzY5NgpMb2dnZWQgYnk6ICAgICAgICAgIFJvbWFuIEdhcmNpYQpFbWFp bCBhZGRyZXNzOiAgICAgIHl6ZXJub0BnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMy4y Ck9wZXJhdGluZyBzeXN0ZW06ICAgbGludXggdWJ1bnR1CkRlc2NyaXB0aW9uOiAgICAgICAgCgpF eGVjdXRpbmcgdGhlIGZvbGxvd2luZyBzaW1wbGUgc2NyaXB0Og0KDQpCRUdJTjsNCkNSRUFURSB0 YWJsZSBmb28gKGlkIGludGVnZXIgcHJpbWFyeSBrZXkpOw0KQ1JFQVRFIFRBQkxFIGJhcihpZCBp bnRlZ2VyLCBmb29faWQgaW50ZWdlcik7DQppbnNlcnQgaW50byBmb28gKGlkKSB2YWx1ZXMgKDEp Ow0KaW5zZXJ0IGludG8gYmFyKGlkLGZvb19pZCkgdmFsdWVzICgxLCAyKTsNCmFsdGVyIHRhYmxl IGJhciBhZGQgY29uc3RyYWludCBmb29fZmtleSBmb3JlaWduIGtleSAoZm9vX2lkKSByZWZlcmVu Y2VzCmZvbyhpZCkgZGVmZXJyYWJsZSBpbml0aWFsbHkgZGVmZXJyZWQ7DQoNCnJlc3VsdHMgaW4g YSBjb25zdHJhaW50IHZpb2xhdGlvbiBlcnJvciBhdCB0aGUgY29uc3RyYWludCBjcmVhdGlvbiBs aW5lOg0KIiBFUlJPUjogIGluc2VydCBvciB1cGRhdGUgb24gdGFibGUgImJhciIgdmlvbGF0ZXMg Zm9yZWlnbiBrZXkgY29uc3RyYWludAoiZm9vX2ZrZXkiIERFVEFJTDogIEtleSAoZm9vX2lkKT0o MikgaXMgbm90IHByZXNlbnQgaW4gdGFibGUgImZvbyIuICINCg0KSSB3b3VsZCBoYXZlIGV4cGVj dGVkIHRvIGdldCB0aGlzIGVycm9yIG1lc3NhZ2UgbGF0ZXIsIGF0IHRyYW5zYWN0aW9uIGNvbW1p dAooaWYgbm8gZm9vIHdpdGggaWQgMiBoYXZlIGJlZW4gaW5zZXJ0ZWQgYmVmb3JlIHRoZW4pIGlu c3RlYWQgb2YgZ2V0dGluZyBpdAphdCBjb25zdHJhaW50IGNyZWF0aW9uLCBzaW5jZSB0aGUgcG9p bnQgb2YgaGF2aW5nIGFuIGRlZmVycmFibGUgaW5pdGlhbGx5CmRlZmVycmVkIGNvbnN0cmFpbnQg aXMgdG8gbW92ZSB0aGUgY29uc3RyYWludCBjaGVjayB3aGVuIHRoZSB0cmFuc2FjdGlvbiBpcwpj b21taXRlZC4NCg0KSSBmb3VuZCBubyBpbmRpY2F0aW9uIG9mIHRoaXMgYmVoYXZpb3VyIGluIHRo ZSBkb2N1bWVudGF0aW9uLCBvbmx5IGFuCmV4YW1wbGUgb2YgdGhlIG9wcG9zaXRlIGNhc2U6IGlm IHRoZXJlIGV4aXN0cyBhbiBhbHJlYWR5IGRlZmluZWQgZGVmZXJyYWJsZQppbml0aWFsbHkgZGVm ZXJyZWQgY29uc3RyYWludCwgYnV0IHdlIHNldCBpdCB0byBpbW1lZGlhdGUgZHVyaW5nIHRyYW5z YWN0aW9uCndpdGggU0VUIENPTlNUUkFJTlRTLCB0aGVuIGl0IGlzIGNoZWNrZWQgaW1tZWRpYXRl bHksIHdoaWNoIHNob3VsZCBiZQpleHBlY3RlZC4KCg== --===============8876822168302147036==--