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 1mQFqi-0002x9-GK for pgsql-committers@arkaria.postgresql.org; Tue, 14 Sep 2021 21:20:16 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mQFqh-0006N1-Ht for pgsql-committers@arkaria.postgresql.org; Tue, 14 Sep 2021 21:20:15 +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 1mQFpI-00051K-2G for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 21:18:48 +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 1mQFpE-0007na-TA for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 21:18:47 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mQFpC-00055v-Jd for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 21:18:42 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mQFpC-0006Af-6g for pgsql-committers@lists.postgresql.org; Tue, 14 Sep 2021 21:18:42 +0000 Content-Type: multipart/mixed; boundary="===============5897356451678761545==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Send NOTIFY signals during CommitTransaction. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 14 Sep 2021 21:18:42 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5897356451678761545== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2VuZCBOT1RJRlkgc2lnbmFscyBkdXJpbmcgQ29tbWl0VHJhbnNhY3Rpb24uCgpGb3JtZXJseSwg d2Ugc2VudCBzaWduYWxzIGZvciBvdXRnb2luZyBOT1RJRlkgbWVzc2FnZXMgd2l0aGluClByb2Nl c3NDb21wbGV0ZWROb3RpZmllcywgd2hpY2ggd2FzIGFsc28gcmVzcG9uc2libGUgZm9yIHNlbmRp bmcKcmVsZXZhbnQgb25lcyBvZiB0aG9zZSBtZXNzYWdlcyB0byBvdXIgY29ubmVjdGVkIGNsaWVu dC4gIEl0IHRoZXJlZm9yZQpoYWQgdG8gcnVuIGR1cmluZyB0aGUgbWFpbi1sb29wIHByb2Nlc3Np bmcgdGhhdCBvY2N1cnMganVzdCBiZWZvcmUKZ29pbmcgaWRsZS4gIFRoaXMgYXJyYW5nZW1lbnQg aGFkIHR3byBiaWcgZGlzYWR2YW50YWdlczoKCiogTm93IHRoYXQgcHJvY2VkdXJlcyBhbGxvdyBp bnRyYS1jb21tYW5kIENPTU1JVHMsIGl0IHdvdWxkIGJlCnVzZWZ1bCB0byBzZW5kIE5PVElGWXMg dG8gb3RoZXIgc2Vzc2lvbnMgaW1tZWRpYXRlbHkgYXQgQ09NTUlUCih0aG91Z2gsIGZvciByZWFz b25zIG9mIHdpcmUtcHJvdG9jb2wgc3RhYmlsaXR5LCB3ZSBzdGlsbCBzaG91bGRuJ3QKZm9yd2Fy ZCB0aGVtIHRvIG91ciBjbGllbnQgdW50aWwgZW5kIG9mIGNvbW1hbmQpLgoKKiBCYWNrZ3JvdW5k IHByb2Nlc3NlcyBzdWNoIGFzIHJlcGxpY2F0aW9uIHdvcmtlcnMgd291bGQgbm90IHNlbmQKTk9U SUZZcyBhdCBhbGwsIHNpbmNlIHRoZXkgbmV2ZXIgZXhlY3V0ZSB0aGUgY2xpZW50IGNvbW11bmlj YXRpb24KbG9vcC4gIFdlJ3ZlIGhhZCByZXF1ZXN0cyB0byBhbGxvdyB0cmlnZ2VycyBydW5uaW5n IGluIHJlcGxpY2F0aW9uCndvcmtlcnMgdG8gc2VuZCBOT1RJRllzLCBzbyB0aGF0J3MgYSBwcm9i bGVtLgoKVG8gZml4IHRoZXNlIHRoaW5ncywgbW92ZSB0cmFuc21pc3Npb24gb2Ygb3V0Z29pbmcg Tk9USUZZIHNpZ25hbHMKaW50byBBdENvbW1pdF9Ob3RpZnksIHdoZXJlIGl0IHdpbGwgaGFwcGVu IGR1cmluZyBDb21taXRUcmFuc2FjdGlvbi4KQWxzbyBtb3ZlIHRoZSBwb3NzaWJsZSBjYWxsIG9m IGFzeW5jUXVldWVBZHZhbmNlVGFpbCB0aGVyZSwgdG8KZW5zdXJlIHdlIGRvbid0IGJsb2F0IHRo ZSBhc3luYyBTTFJVIGlmIGEgYmFja2dyb3VuZCB3b3JrZXIgc2VuZHMKbWFueSBOT1RJRllzIHdp dGggbm8gb25lIGxpc3RlbmluZy4KCldlIGNhbiBhbHNvIGRyb3AgdGhlIGNhbGwgb2YgYXN5bmNR dWV1ZVJlYWRBbGxOb3RpZmljYXRpb25zLAphbGxvd2luZyBQcm9jZXNzQ29tcGxldGVkTm90aWZp ZXMgdG8gZ28gYXdheSBlbnRpcmVseS4gIFRoYXQncwpiZWNhdXNlIGNvbW1pdCA3OTAwMjY5NzIg YWRkZWQgYSBjYWxsIG9mIFByb2Nlc3NOb3RpZnlJbnRlcnJ1cHQKYWRqYWNlbnQgdG8gUG9zdGdy ZXNNYWluJ3MgY2FsbCBvZiBQcm9jZXNzQ29tcGxldGVkTm90aWZpZXMsCmFuZCB0aGF0IGRvZXMg aXRzIG93biBjYWxsIG9mIGFzeW5jUXVldWVSZWFkQWxsTm90aWZpY2F0aW9ucywKbWVhbmluZyB0 aGF0IHdlIHdlcmUgdXNlbGVzc2x5IGRvaW5nIHR3byBzdWNoIGNhbGxzIChpbnNpZGUgdHdvCnNl cGFyYXRlIHRyYW5zYWN0aW9ucykgd2hlbmV2ZXIgaW5ib3VuZCBub3RpZnkgc2lnbmFscyBjb2lu Y2lkZWQKd2l0aCBhbiBvdXRib3VuZCBub3RpZnkuICBXZSBuZWVkIG9ubHkgc2V0IG5vdGlmeUlu dGVycnVwdFBlbmRpbmcKdG8gZW5zdXJlIHRoYXQgUHJvY2Vzc05vdGlmeUludGVycnVwdCBydW5z LCBhbmQgd2UncmUgZG9uZS4KClRoZSBleGlzdGluZyBkb2N1bWVudGF0aW9uIHN1Z2dlc3RzIHRo YXQgY3VzdG9tIGJhY2tncm91bmQgd29ya2VycwpzaG91bGQgY2FsbCBQcm9jZXNzQ29tcGxldGVk Tm90aWZpZXMgaWYgdGhleSB3YW50IHRvIHNlbmQgTk9USUZZCm1lc3NhZ2VzLiAgVG8gYXZvaWQg YW4gQUJJIGJyZWFrIGluIHRoZSBiYWNrIGJyYW5jaGVzLCByZWR1Y2UgaXQKdG8gYW4gZW1wdHkg cm91dGluZSByYXRoZXIgdGhhbiByZW1vdmluZyBpdCBlbnRpcmVseS4gIFJlbW92YWwKd2lsbCBv Y2N1ciBpbiB2MTUuCgpBbHRob3VnaCB0aGUgcHJvYmxlbXMgbWVudGlvbmVkIGFib3ZlIGhhdmUg ZXhpc3RlZCBmb3IgYXdoaWxlLApJIGRvbid0IGZlZWwgY29tZm9ydGFibGUgYmFjay1wYXRjaGlu ZyB0aGlzIGFueSBmdXJ0aGVyIHRoYW4gdjEzLgpUaGVyZSB3YXMgcXVpdGUgYSBiaXQgb2YgY2h1 cm4gaW4gYWRqYWNlbnQgY29kZSBiZXR3ZWVuIDEyIGFuZCAxMy4KQXQgbWluaW11bSB3ZSdkIGhh dmUgdG8gYWxzbyBiYWNrcGF0Y2ggNTEwMDRjNzE3LCBhbmQgYSBnb29kIGRlYWwKb2Ygb3RoZXIg YWRqdXN0bWVudCB3b3VsZCBhbHNvIGJlIG5lZWRlZCwgc28gdGhlIGJlbmVmaXQtdG8tcmlzawpy YXRpbyBkb2Vzbid0IGxvb2sgYXR0cmFjdGl2ZS4KClBlciBidWcgIzE1MjkzIGZyb20gTWljaGFl bCBQb3dlcnMgKGFuZCBzaW1pbGFyIGdyaXBlcyBmcm9tIG90aGVycykuCgpBcnR1ciBaYWtpcm92 IGFuZCBUb20gTGFuZQoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8xNTMyNDM0NDE0 NDkuMTQwNC4yMjc0MTE2MjI4NTA2MTc1NTk2QHdyaWdsZXlzLnBvc3RncmVzcWwub3JnCgpCcmFu Y2gKLS0tLS0tClJFTF8xM19TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0 Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzYzZjI4Nzc2Y2I5ZmJlZmQ5OWM1ZTIxMzRmMDJjODAw NTdiOGI3MTcKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9iZ3dv cmtlci5zZ21sICAgICAgICB8ICAxNiArKy0Kc3JjL2JhY2tlbmQvYWNjZXNzL3RyYW5zYW0veGFj dC5jIHwgIDEwICsrCnNyYy9iYWNrZW5kL2NvbW1hbmRzL2FzeW5jLmMgICAgICB8IDIwNyArKysr KysrKysrKysrKysrKystLS0tLS0tLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC90Y29wL3Bvc3Rn cmVzLmMgICAgICAgfCAgMTYgKystCnNyYy9pbmNsdWRlL2NvbW1hbmRzL2FzeW5jLmggICAgICB8 ICAgMiArLQo1IGZpbGVzIGNoYW5nZWQsIDEyMiBpbnNlcnRpb25zKCspLCAxMjkgZGVsZXRpb25z KC0pCgo= --===============5897356451678761545==--