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 1nlaYk-00025z-QC for pgsql-docs@arkaria.postgresql.org; Mon, 02 May 2022 18:14:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nlaYi-0006yS-32 for pgsql-docs@arkaria.postgresql.org; Mon, 02 May 2022 18:14:08 +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 1nla2n-0002ds-VC for pgsql-docs@lists.postgresql.org; Mon, 02 May 2022 17:41:10 +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 1nla2j-00035p-4t for pgsql-docs@lists.postgresql.org; Mon, 02 May 2022 17:41:09 +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=70VNN0FiTtGGNUGtJ79lO5F/YXvTX3pDCOze3xO1FZk=; b=n5QVr8E4P9UeIAS76/UIgubmAb LPca1jwuzsyULMa8h6GBww0bdkyq+1sLgvM+31Yumr5s0WEnjFRyqT850pxJN3lOb+om99XNRkst3 FhWEFa4DcNbkX8Gi1cf/m5mbv0kh4pFhEqDwmg5zRX87GXYmoW92FtrDLrIsu3SoPSTv+fn3ysUxT +ZmH5qW4T7JqHcrpulhXwPFXNfGZ7WmFWkyxj1w+/yVlX7//+L13/gItwwCTWncdO/r/eEp5bs0M+ 8E6iZBV+DrgHBRJiKLlP2U7uciacaShi5uGtOPfm9Qipei5Kf59ptPcpXP2VEZNZvWl2q62NNFMD0 UYgxs/UA==; 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 1nla2h-0001BU-QK for pgsql-docs@lists.postgresql.org; Mon, 02 May 2022 17:41:03 +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 1nla2f-008RSK-Ri for pgsql-docs@lists.postgresql.org; Mon, 02 May 2022 17:41:02 +0000 Content-Type: multipart/mixed; boundary="===============0360160324326656922==" MIME-Version: 1.0 Subject: Clarification of triggers with 'OF column_name' in 'Overview of Trigger Behavior' To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: josh.ag@paladin.insure Reply-To: josh.ag@paladin.insure, pgsql-docs@lists.postgresql.org Date: Mon, 02 May 2022 17:40:18 +0000 Message-ID: <165151321896.685.16545084197561479198@wrigleys.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 --===============0360160324326656922== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMy90cmln Z2VyLWRhdGFjaGFuZ2VzLmh0bWwKRGVzY3JpcHRpb246CgpUaGlzIGNhdWdodCBtZSBvdXQgYmVj YXVzZSBJIHdhcyBsb29raW5nIGF0IHRoZSB3cm9uZyBwYWdlLCBzbyBJIGZpZ3VyZWQgaXQKbWln aHQgYmUgYSBnb29kIGFkZGl0aW9uLiBJJ20gcnVubmluZyB2ZXJzaW9uICdQb3N0Z3JlU1FMIDEz LjIgKERlYmlhbgoxMy4yLTEucGdkZzEwMCsxKSBvbiB4ODZfNjQtcGMtbGludXgtZ251LCBjb21w aWxlZCBieSBnY2MgKERlYmlhbiA4LjMuMC02KQo4LjMuMCwgNjQtYml0Jw0KDQpJZiBJIGhhdmUN Cg0KQ1JFQVRFIFRBQkxFIHRlc3QgKCBhbHBoYSBpbnRlZ2VyLCBiZXRhIGludGVnZXIsIGNoYXJs aWUgaW50ZWdlcik7DQpDUkVBVEUgRlVOQ1RJT04gYWIoKSBSRVRVUk5TIFRSSUdHRVINCkxBTkdV QUdFIHBscGdzcWwNCiAgICBBUyAkXyQNCkJFR0lODQogICAgUkFJU0UgSU5GTyAnJTogYWIgZmly aW5nJywgY2xvY2tfdGltZXN0YW1wKCk7DQogICAgSUYgTkVXLmFscGhhIC0gT0xELmFscGhhID49 IDUgVEhFTiANCiAgICAgICAgTkVXLmJldGEgPSBORVcuYmV0YSArIDE7DQogICAgRU5EIElGOw0K ICAgIFJFVFVSTiBORVc7DQpFTkQ7DQokXyQ7DQpDUkVBVEUgRlVOQ1RJT04gYmMoKSBSRVRVUk5T IFRSSUdHRVINCkxBTkdVQUdFIHBscGdzcWwNCiAgICBBUyAkXyQNCkJFR0lODQogICAgICAgIFJB SVNFIElORk8gJyU6IGJjIGZpcmluZycsIGNsb2NrX3RpbWVzdGFtcCgpOw0KICAgIElGIE5FVy5i ZXRhIElTIERJU1RJTkNUIEZST00gT0xELmJldGEgVEhFTiANCiAgICAgICAgTkVXLmNoYXJsaWUg PSBORVcuY2hhcmxpZSArIDE7DQogICAgRU5EIElGOw0KICAgIFJFVFVSTiBORVc7DQpFTkQ7DQok XyQ7DQpDUkVBVEUgVFJJR0dFUiBiMl9hYiBCRUZPUkUgVVBEQVRFIE9GIGFscGhhIE9OIHRlc3Qg Rk9SIEVBQ0ggUk9XIEVYRUNVVEUKRlVOQ1RJT04gYWIoKTsNCkNSRUFURSBUUklHR0VSIGIzX2Jj IEJFRk9SRSBVUERBVEUgT0YgYmV0YSBPTiB0ZXN0IEZPUiBFQUNIIFJPVyBFWEVDVVRFCkZVTkNU SU9OIGJjKCk7DQoNCklOU0VSVCBJTlRPIHRlc3QgKGFscGhhLCBiZXRhLCBjaGFybGllKSBWQUxV RVMgKDAsMCwwKTsNCg0KdGhlbiB3aGVuIHJ1bm5pbmcNCg0KVVBEQVRFIHRlc3QgU0VUIGFscGhh ID0gNTsNCg0Kb25seSB0cmlnZ2VyIGIyX2FiIHdpbGwgZmlyZSwgZXZlbiB0aG91Z2ggaXQgd2ls bCB1cGRhdGUgY29sdW1uIGJldGEuIElmIGkKY2hhbmdlIHRoZSBkZWNsYXJhdGlvbiBvZiBiM19i YyBieSByZW1vdmluZyB0aGUgY29sdW1uIGxpc3Qgb3IgaW5jbHVkaW5nCmNvbHVtbiBhbHBoYSwg dGhpbmdzIHdvcmsgYXMgSSBleHBlY3RlZCBhbmQgYjJfYWIgY2FzY2FkZXMgdG8gYjNfYmMuDQoN ClRoaXMgc3BlY2lmaWMgYmVoYXZpb3IgaXMgbWVudGlvbmVkIGluIHRoZSBzcWwgZG9jdW1lbnRh dGlvbiByZWZlcmVuY2UgZm9yCkNSRUFURSBUUklHR0VSLCBidXQgSSB0aGluayBhdCBsZWFzdCBh IG1lbnRpb24gb2YgdGhpcyB3b3VsZCBiZSB1c2VmdWwgb24KdGhpcyBwYWdlIGFzIHdlbGwgc2lt aWxhciB0byBob3cgV0hFTiBjb25kaXRpb25zIGFyZSBtZW50aW9uZWQgb24gYm90aApwYWdlcy4K --===============0360160324326656922==--