Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f1Vkk-0007Er-HQ for pgsql-sql@arkaria.postgresql.org; Thu, 29 Mar 2018 11:29:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f1Vki-0006hh-Lf for pgsql-sql@arkaria.postgresql.org; Thu, 29 Mar 2018 11:29:56 +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 1f1Vki-0006hX-Ci for pgsql-sql@lists.postgresql.org; Thu, 29 Mar 2018 11:29:56 +0000 Received: from forward3p.cmail.yandex.net ([2a02:6b8:0:1465::13]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f1Vkf-0002aT-Bu for pgsql-sql@postgresql.org; Thu, 29 Mar 2018 11:29:55 +0000 Received: from mxback10g.mail.yandex.net (mxback10g.mail.yandex.net [IPv6:2a02:6b8:0:1472:2741:0:8b7:171]) by forward3p.cmail.yandex.net (Yandex) with ESMTP id EAF9921087; Thu, 29 Mar 2018 14:29:50 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback10g.mail.yandex.net (nwsmtp/Yandex) with ESMTP id IxtR7Z3SbI-ToQCcmHJ; Thu, 29 Mar 2018 14:29:50 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1522322990; bh=p1lyCBVzU8ldfUOesxx9GbdZal1MZkAO2oPnakU5tc4=; h=From:To:In-Reply-To:References:Subject:Message-Id:Date; b=nLp4adwUHBfERlIVOBfCbJzRBC4YIIZs71VKxsI+t2FaptACmkBCU0A58nCuvoWq8 RRJBSPeIJEXKXxnTcMs07an+ZW+QwGLttxyeVJ1TFHIbyIYINnSvJDKGwf8QQIgLVZ q6bkEzWmyGnXtUIdAE+IAc/lwZdFW575PTTdxb8w= Authentication-Results: mxback10g.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by web29o.yandex.ru with HTTP; Thu, 29 Mar 2018 14:29:50 +0300 From: Samed YILDIRIM To: abctevez , "pgsql-sql@postgresql.org" In-Reply-To: <3b1b40d4.7fc7.1627081ce30.Coremail.swqshapu@163.com> References: <3b1b40d4.7fc7.1627081ce30.Coremail.swqshapu@163.com> Subject: Re: when transaction is committed in postgres MIME-Version: 1.0 Message-Id: <8393341522322990@web29o.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Thu, 29 Mar 2018 14:29:50 +0300 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj5IaSBSaWNoYXJkLDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PlRoZXJlIGFyZSBtb3JlIHRo YW4gb25lIG9wdGlvbiB5b3UgY2FuIHVzZS48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj48c3Ryb25n PjEuIFR3by1waGFzZSBjb21taXQ8L3N0cm9uZz48L2Rpdj48ZGl2PllvdSBjYW4gcHJlcGFyZSB5 b3VyIHRyYW5zYWN0aW9ucyB3aXRoIHVuaXF1ZSBpZCBiZWZvcmUgY29tbWl0LjwvZGl2PjxkaXY+ LSBJZiB0aGUgY29ubmVjdGlvbiBiZXR3ZWVuIGNsaWVudCBhbmQgcG9zdGdyZXMgaXMgbG9zdCBh dCBwcmVwYXJhdGlvbiBwaGFzZSAoUFJFUEFSRSBUUkFOU0FDVElPTiksIHlvdSBjYW4gY29udHJv bCBpdCB3aXRoIHBnX3ByZXBhcmVkX3hhY3RzIHN5c3RlbSB2aWV3IHdoZXRoZXIgaXQgY2FuIGJl IGNvbW1pdHRlZC4gSWYgeW91IGNhbiBzZWUgeW91ciB0cmFuc2FjdGlvbiBvbiB0aGUgc3lzdGVt IHZpZXcsIHlvdSBjYW4gY29tbWl0IHRoZSB0cmFuc2FjdGlvbiAoQ09NTUlUIFBSRVBBUkVEKS48 L2Rpdj48ZGl2Pi0gSWYgdGhlIGNvbm5lY3Rpb24gYmV0d2VlbiBjbGllbnQgYW5kIHBvc3RncmVz IGlzIGxvc3QgYXQgY29tbWl0IHBoYXNlIG9mIHRoZSBwcmVwYXJlZCB0cmFuc2FjdGlvbiwgeW91 IGNhbiBjb250cm9sIGl0IHdpdGggdXNpbmcgcGdfcHJlcGFyZWRfeGFjdHMgc3lzdGVtIHZpZXcg YWdhaW4gOikgSWYgeW91IGNhbiBzZWUgeW91ciB0cmFuc2FjdGlvbiBpZCwgaXQgaXMgd2FpdGlu ZyBmb3IgY29tbWl0LiBJZiB5b3UgZG8gbm90IHNlZSwgSXQgaXMgY29tbWl0dGVkIChvZiBjb3Vy c2UgaWYgeW91IGRvbid0IGV4ZWN1dGUgUk9MTEJBQ0sgUFJFUEFSRUQgY29tbWFuZCkuPC9kaXY+ PGRpdj7CoDwvZGl2PjxkaXY+PGEgaHJlZj0iaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9j cy8xMC9zdGF0aWMvc3FsLXByZXBhcmUtdHJhbnNhY3Rpb24uaHRtbCI+aHR0cHM6Ly93d3cucG9z dGdyZXNxbC5vcmcvZG9jcy8xMC9zdGF0aWMvc3FsLXByZXBhcmUtdHJhbnNhY3Rpb24uaHRtbDwv YT48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj48c3Ryb25nPjIuPC9zdHJvbmc+IDxzdHJvbmc+VHJh Y2sgY29tbWl0IHRpbWVzdGFtcDwvc3Ryb25nPjwvZGl2PjxkaXY+RW5hYmxlIGl0ICh0cmFja19j b21taXRfdGltZXN0YW1wID0gb24pIGluIHBvc3RncmVzcWwuY29uZiBmaXJzdC4gSW4geW91ciB0 cmFuc2FjdGlvbiwgZ2V0IHlvdXIgdHJhbnNhY3Rpb24gaWQgYnkgdXNpbmcgdHhpZF9jdXJyZW50 KCkgZnVuY3Rpb24uIElmIHRoZSBjb25uZWN0aW9uIGJldHdlZW4gY2xpZW50IGFuZCBwb3N0Z3Jl cyBpcyBsb3N0LCB5b3UgY2FuIGNoZWNrIHlvdXIgdHJhbnNhY3Rpb24gaXMgY29tbWl0dGVkIG9y IG5vdCBieSB1c2luZyBwZ194YWN0X2NvbW1pdF90aW1lc3RhbXAoKSBmdW5jdGlvbi4gSWYgaXQg cmV0dXJucyBudWxsLCBJdCB5b3VyIHRyYW5zYWN0aW9uIGlzIG5vdCBjb21taXR0ZWQuIElmIHJl dHVybnMgYSB0aW1lc3RhbXAsIHlvdXIgdHJhbnNhY3Rpb24gaXMgY29tbWl0dGVkLjwvZGl2Pjxk aXY+wqA8L2Rpdj48ZGl2PjxkaXY+PGEgaHJlZj0iaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcv ZG9jcy8xMC9zdGF0aWMvZnVuY3Rpb25zLWluZm8uaHRtbCI+aHR0cHM6Ly93d3cucG9zdGdyZXNx bC5vcmcvZG9jcy8xMC9zdGF0aWMvZnVuY3Rpb25zLWluZm8uaHRtbDwvYT48L2Rpdj48L2Rpdj48 ZGl2PsKgPC9kaXY+PGRpdj48c3Ryb25nPjMuPC9zdHJvbmc+IDxzdHJvbmc+dHhpZF9zdGF0dXMo KSBmdW5jdGlvbjwvc3Ryb25nPjwvZGl2PjxkaXY+SWYgeW91IGFyZSB1c2luZyBQb3N0Z3JlU1FM IDEwLCB5b3UgY2FuIGNoZWNrIHlvdXIgdHJhbnNhY3Rpb24gc3RhdHVzIChjb21taXR0ZWQsIGFi b3J0ZWQgb3IgaW4gcHJvZ3Jlc3MpIGRpcmVjdGx5IHdpdGggdHJhbnNhY3Rpb24gaWQuPC9kaXY+ PGRpdj7CoDwvZGl2PjxkaXY+PGEgaHJlZj0iaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9j cy8xMC9zdGF0aWMvZnVuY3Rpb25zLWluZm8uaHRtbCI+aHR0cHM6Ly93d3cucG9zdGdyZXNxbC5v cmcvZG9jcy8xMC9zdGF0aWMvZnVuY3Rpb25zLWluZm8uaHRtbDwvYT48L2Rpdj48ZGl2PsKgPC9k aXY+PGRpdj5CZXN0IHJlZ2FyZHMuPC9kaXY+PGRpdj5TYW1lZCBZSUxESVJJTTwvZGl2PjxkaXY+ wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj4yOS4wMy4yMDE4LCAwOTo1OSwgImFiY3RldmV6IiAm bHQ7c3dxc2hhcHVAMTYzLmNvbSZndDs6PC9kaXY+PGJsb2NrcXVvdGUgdHlwZT0iY2l0ZSI+PGRp diBzdHlsZT0ibGluZS1oZWlnaHQ6MS43O2NvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7Zm9u dC1mYW1pbHk6QXJpYWw7Ij48ZGl2IHN0eWxlPSJsaW5lLWhlaWdodDoxLjc7Y29sb3I6IzAwMDAw MDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTpBcmlhbDsiPjxkaXY+wqAgwqAgwqAgSGVsbG8s SSByZWFkIHRoZSBpbnRyb2R1Y3Rpb24gb2YgdHJhbnNhY3Rpb24gb24gdGhlIHBvc3RncmVzcWwg b2ZmaWNpYWwgd2Vic2l0ZS4gSXQgbm90ZXMgdGhhdCB0cmFuc2FjdGlvbiBpcyBjb21taXR0ZWQg d2hlbiBjb21taXQgY2FsbC48L2Rpdj48ZGl2PsKgIMKgIMKgIFN1cHBvc2UgdGhhdCAsIEkgZXhl Y3V0ZSBiZWdpbuOAgWV4ZWN1dGUgY29tbWFuZCBhbmQgdGhlbiBjb21taXQgdXNpbmcgc29tZSBw b3N0Z3JlcyBjbGllbnQgc3VjaCBhcyBqZGJjIG9yIG9kYmMsIHdoYXQgaGFwcGVucyBpZiB0aGUg cG9zdGdyZXNxbCBzZXJ2ZXIgcmVjZWl2ZSBjb21taXQgY29tbWFuZCBhbmQgcmVzcG9uc2UgY29t bWl0IG1lc3NhZ2UgZmFpbHVyZSxsaWtlIHRjcCBzaGFrZWhhbmQ/SWYgaXQgaXMgc3RpbGwgdG8g YmUgY29tbWl0dGVkLCB0aGUgY2xpZW50IGhhcyBubyB3YXkgdG8ga25vdyB3aGV0aGVyIHRoZSB0 cmFuc2FjdGlvbiBpcyBjb21taXR0ZWQgc3VjY2Vzc2Z1bGx5IG9yIG5vdC5Ib3cgZG9lcyBwb3N0 Z3Jlc3FsIGhhbmRsZSBzdWNoIHNpdHVhdGlvbjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PlRoYW5r cyBhZHZhbmNlczwvZGl2PjxkaXY+UmljaGFyZDwvZGl2PjwvZGl2PsKgPHA+PHNwYW4gdGl0bGU9 Im5ldGVhc2Vmb290ZXIiPsKgPC9zcGFuPjwvcD48L2Rpdj7CoDxwPjxzcGFuIHRpdGxlPSJuZXRl YXNlZm9vdGVyIj7CoDwvc3Bhbj48L3A+PC9ibG9ja3F1b3RlPg==