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 1q6XCh-0007wS-Jp for pgsql-docs@arkaria.postgresql.org; Tue, 06 Jun 2023 13:58:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q6XCg-0006ot-4u for pgsql-docs@arkaria.postgresql.org; Tue, 06 Jun 2023 13:58:30 +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 1q6XCf-0006ok-Qw for pgsql-docs@lists.postgresql.org; Tue, 06 Jun 2023 13:58:29 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q6XCY-000am8-PB for pgsql-docs@lists.postgresql.org; Tue, 06 Jun 2023 13:58:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:Subject:To:From:MIME-Version: Date:Message-ID:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=AhBajuSH+SK5SArY3DblcFRSofPuaT55ymswKoYo0yo=; b=KF10Vu5Oo3ZpfHqmFlVSXS+pTT Z0oIFoDTiee0qzPdLBkhCPZ3rOolOO8LBdrtVYqe7KQbZBJW7SQduxQ187rRA4sRy28zyKp6fONC4 fiowcLy2zxD/ldzYd2wrbGHZIqV1SRRdY8k6o0WFKWqGDrebHT2aFyBYuTPAYFYr3/CFpckEmCN43 nUuOpfSzKdeadYOhyX+q56Tzzu2hdioQ7hhbkrFS9iPASvETwcXhMWgg0XTMgsHGYHxa8Y3exucoQ QL9jCKz0tlBFqhXvm3rBlQrarC+38cXL+l93Evxo4q376vmk1U5yvAO/MzB6v0w5pkE1yIL9oKb/e zazU55tg==; Received: from [52.119.84.106] (helo=[192.168.88.177]) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q6XCU-001pLJ-Pm for pgsql-docs@lists.postgresql.org; Tue, 06 Jun 2023 13:58:22 +0000 Message-ID: <5bb2c9a2-499f-e1a2-6e33-5ce96b35cc4a@postgresql.org> Date: Tue, 6 Jun 2023 09:58:14 -0400 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Content-Language: en-US From: "Jonathan S. Katz" To: Pg Docs Subject: clarifying trigger/rule behavior on logical replication subscribers Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------n4ZGRk4Af2KCftRjTYqmMXBZ" X-Host-Lookup-Failed: Reverse DNS lookup failed for 52.119.84.106 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------n4ZGRk4Af2KCftRjTYqmMXBZ Content-Type: multipart/mixed; boundary="------------3RyOD4O5dwLFHPE48wh8gsY7"; protected-headers="v1" From: "Jonathan S. Katz" To: Pg Docs Message-ID: <5bb2c9a2-499f-e1a2-6e33-5ce96b35cc4a@postgresql.org> Subject: clarifying trigger/rule behavior on logical replication subscribers --------------3RyOD4O5dwLFHPE48wh8gsY7 Content-Type: multipart/mixed; boundary="------------aCMct4HFXAWuZJGgZ0QxBpdP" --------------aCMct4HFXAWuZJGgZ0QxBpdP Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 SGksDQoNCldoaWxlIGFuc3dlcmluZyBhIHF1ZXN0aW9uIG9uICJkbyB0cmlnZ2VycyBmaXJl IG9uIGEgbG9naWNhbCByZXBsaWNhdGlvbiANCnN1YnNjcmliZXIgYnkgZGVmYXVsdD8iIEkg dHJpZWQgdG8gbG9vayB1cCBhIHJlZmVyZW5jZSB0byB0aGlzIGJlaGF2aW9yIA0KaW4gdGhl IGRvY3MuIFRoZXJlIHdhc24ndCBhIGNsZWFyIHJlZmVyZW5jZSBwb2ludCwgYnV0IG9uIHRo ZSANCmFyY2hpdGVjdHVyZSBwYWdlWzFdLCBJIGZvdW5kIHRoaXMgbGluZSB0aGF0IHdhcyBj bG9zZXN0IHRvIHRoZSBhbnN3ZXI6DQoNCiJUaGUgYXBwbHkgcHJvY2VzcyBvbiB0aGUgc3Vi c2NyaWJlciBkYXRhYmFzZSBhbHdheXMgcnVucyB3aXRoIA0Kc2Vzc2lvbl9yZXBsaWNhdGlv bl9yb2xlIHNldCB0byByZXBsaWNhLCB3aGljaCBwcm9kdWNlcyB0aGUgdXN1YWwgDQplZmZl Y3RzIG9uIHRyaWdnZXJzIGFuZCBjb25zdHJhaW50cy4iDQoNCndoaWNoIGFzc3VtZXMgdGhh dCB0aGUgcmVhZGVyIGtub3dzIHdoYXQgdGhlICJ1c3VhbCBlZmZlY3RzIiBhcmUuDQoNCkF0 dGFjaGVkIGlzIGEgcGF0Y2ggdGhhdCBkaXNhbWJpZ3VhdGVzIHRoaXMuDQoNClR3byBhZGRp dGlvbmFsIGl0ZW1zOg0KDQoxLiBJIGRvIHRoaW5rIHRoaXMgc2hvdWxkIGJlIGJhY2twYXRj aGVkIGJlY2F1c2UgaXQgY2xhcmlmaWVzIGFuIA0KZXhpc3RpbmcgYmVoYXZpb3IuDQoNCjIu IEkgZG9uJ3Qga25vdyBpZiB3ZSB3YW50IHRvIGFkZCBhIG5vdGUgYWJvdXQgdGhlIHRyaWdn ZXIvcnVsZSBiZWhhdmlvciANCmVsc2V3aGVyZSBpbiB0aGUgbG9naWNhbCByZXBsaWNhdGlv biBzZWN0aW9uLiBJIGRvbid0IGtub3cgaWYgYSByZWFkZXIgDQp3b3VsZCBiZSBleHBlY3Rp bmcgdG8gZmluZCB0aGlzIGluIHRoZSAiYXJjaGl0ZWN0dXJlIiBzZWN0aW9uLg0KDQpUaGFu a3MsDQoNCkpvbmF0aGFuDQoNClsxXSANCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2Rv Y3MvZGV2ZWwvbG9naWNhbC1yZXBsaWNhdGlvbi1hcmNoaXRlY3R1cmUuaHRtbA0K --------------aCMct4HFXAWuZJGgZ0QxBpdP Content-Type: text/plain; charset=UTF-8; name="v1-0001-doc-Clarify-behavior-of-triggers-rules-in-a-logical-.patch" Content-Disposition: attachment; filename*0="v1-0001-doc-Clarify-behavior-of-triggers-rules-in-a-logical-"; filename*1=".patch" Content-Transfer-Encoding: base64 RnJvbSAyM2FhYTdmZTQwMWQ4NTczNmViZjQyNjYyNmIwNjMwNzVhNzVjOTE4IE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiAiSm9uYXRoYW4gUy4gS2F0eiIgPGpvbmF0aGFuLmth dHpAZXhjb3ZlbnR1cmVzLmNvbT4KRGF0ZTogVHVlLCA2IEp1biAyMDIzIDA5OjUxOjMyIC0w NDAwClN1YmplY3Q6IFtQQVRDSF0gZG9jOiBDbGFyaWZ5IGJlaGF2aW9yIG9mIHRyaWdnZXJz L3J1bGVzIGluIGEgbG9naWNhbAogc3Vic2NyaWJlcgoKQnkgZGVmYXVsdCwgdHJpZ2dlcnMg YW5kIHJ1bGVzIGRvIG5vdCBmaXJlIG9uIGEgbG9naWNhbCByZXBsaWNhdGlvbgpzdWJzY3Jp YmVyIGJhc2VkIG9uIHRoZSAic2Vzc2lvbl9yZXBsaWNhdGlvbl9yb2xlIiBHVUMgYmVpbmcg c2V0IHRvCiJyZXBsaWNhIi4gSG93ZXZlciwgdGhlIGRvY3MgaW4gdGhlIGxvZ2ljYWwgcmVw bGljYXRpb24gc2VjdGlvbiBhc3N1bWVkCnRoYXQgdGhlIHJlYWRlciB1bmRlcnN0b29kIGhv dyB0aGlzIEdVQyB3b3JrZWQuIFRoaXMgbW9kaWZpZXMgdGhlIGRvY3MgdG8KYmUgbW9yZSBl eHBsaWNpdCwgYW5kIGxpbmsgYmFjayB0byB0aGUgR1VDIGl0c2VsZi4KLS0tCiBkb2Mvc3Jj L3NnbWwvbG9naWNhbC1yZXBsaWNhdGlvbi5zZ21sIHwgMTAgKysrKysrKy0tLQogMSBmaWxl IGNoYW5nZWQsIDcgaW5zZXJ0aW9ucygrKSwgMyBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQg YS9kb2Mvc3JjL3NnbWwvbG9naWNhbC1yZXBsaWNhdGlvbi5zZ21sIGIvZG9jL3NyYy9zZ21s L2xvZ2ljYWwtcmVwbGljYXRpb24uc2dtbAppbmRleCA1OWNmOTJlNmE5Li5iMThjZmY3M2Vk IDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvbG9naWNhbC1yZXBsaWNhdGlvbi5zZ21sCisr KyBiL2RvYy9zcmMvc2dtbC9sb2dpY2FsLXJlcGxpY2F0aW9uLnNnbWwKQEAgLTE2NTQsOSAr MTY1NCwxMyBAQCBDT05URVhUOiAgcHJvY2Vzc2luZyByZW1vdGUgZGF0YSBmb3IgcmVwbGlj YXRpb24gb3JpZ2luICJwZ18xNjM5NSIgZHVyaW5nICJJTlNFUgogCiAgIDxwYXJhPgogICAg VGhlIGFwcGx5IHByb2Nlc3Mgb24gdGhlIHN1YnNjcmliZXIgZGF0YWJhc2UgYWx3YXlzIHJ1 bnMgd2l0aAotICAgPHZhcm5hbWU+c2Vzc2lvbl9yZXBsaWNhdGlvbl9yb2xlPC92YXJuYW1l PiBzZXQKLSAgIHRvIDxsaXRlcmFsPnJlcGxpY2E8L2xpdGVyYWw+LCB3aGljaCBwcm9kdWNl cyB0aGUgdXN1YWwgZWZmZWN0cyBvbiB0cmlnZ2VycwotICAgYW5kIGNvbnN0cmFpbnRzLgor ICAgPGxpbmsgbGlua2VuZD0iZ3VjLXNlc3Npb24tcmVwbGljYXRpb24tcm9sZSI+PHZhcm5h bWU+c2Vzc2lvbl9yZXBsaWNhdGlvbl9yb2xlPC92YXJuYW1lPjwvbGluaz4KKyAgIHNldCB0 byA8bGl0ZXJhbD5yZXBsaWNhPC9saXRlcmFsPi4gVGhpcyBtZWFucyB0aGF0LCBieSBkZWZh dWx0LAorICAgdHJpZ2dlcnMgYW5kIHJ1bGVzIHdpbGwgbm90IGZpcmUgb24gYSByZXBsaWNh LiBVc2VycyBjYW4gb3B0aW9uYWxseSBjaG9vc2UgdG8KKyAgIGVuYWJsZSB0cmlnZ2VycyBh bmQgcnVsZXMgb24gYSB0YWJsZSB1c2luZyB0aGUKKyAgIDxsaW5rIGxpbmtlbmQ9InNxbC1h bHRlcnRhYmxlIj48Y29tbWFuZD5BTFRFUiBUQUJMRTwvY29tbWFuZD48L2xpbms+IGNvbW1h bmQKKyAgIGFuZCB0aGUgbGl0ZXJhbD5FTkFCTEUgVFJJR0dFUjwvbGl0ZXJhbD4gYW5kIDxs aXRlcmFsPkVOQUJMRSBSVUxFPC9saXRlcmFsPgorICAgY2xhdXNlcy4KICAgPC9wYXJhPgog CiAgIDxwYXJhPgotLSAKMi4zNy4xIChBcHBsZSBHaXQtMTM3LjEpCgo= --------------aCMct4HFXAWuZJGgZ0QxBpdP-- --------------3RyOD4O5dwLFHPE48wh8gsY7-- --------------n4ZGRk4Af2KCftRjTYqmMXBZ Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wsF5BAABCAAjFiEE+oS2la8r95ogZD/x8QSccp8cZScFAmR/O3YFAwAAAAAACgkQ8QSccp8cZSdA ERAAjrVOizLdlclBVBpr47rYmI+3iGvZYz+5y/Yw3Q92qDXbTowFEJH3wse9jEnWS/CthxzKHvWW pqw3Ue/MMP/Xhj6KZm4GS0OLsS4fHPWjHjrz31qM4p440RrZnd70KsvPbZy5NIG7QRAzZ2KFFIWr u3+hSzKBemoUWQ8Mfd0eWnZSBC+u+0D4mhe+aueYvrn9ll01PvGrGsjwgrpaTPWfpNqq08AFWMzn c/xUC1cocyJTWLMzlyDeCYXh8eCxljZl+OT+2EjlofclE/SI1vu4YbEf8Wx4+uPV5YkwJBZbNdim A5C7WXWYpXrUCtqe97RgAVSAx5MlkVHy2DnNlltOke5NUlpEqj/4JhuVBSU/vTx9tfsCH7cFxngn soyndsUrtKCbkPPNPyFLKmMTooSVzuULGtHgC6OxuWTB1gqc7L/SA85JxFKeae0yGjJY/sF5vjEN Oav7WOC7i/LWPbRILlMSM2XescXRxiWPh+dWuADnbSNMVxMiN5trsPXl72Rl0TwuGHuqKd4WqAMD 82ema8jylH+DDi9Zfi8pTemWJOUxRmnEOxykbnRg9ice+N7mByoxYS8WxPdzXwdNpS3fvRC2fTgJ HcdJWBzvTX0of9fiz7meADr/Ua/QeD8wfNysPSjZCqlJC4LnjQn8zEsYHqFemajtDypi78C7lFSI hVU= =8IU5 -----END PGP SIGNATURE----- --------------n4ZGRk4Af2KCftRjTYqmMXBZ--