Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1igoLx-0000gq-8c for pgsql-docs@arkaria.postgresql.org; Mon, 16 Dec 2019 11:15:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1igoLv-00074K-1c for pgsql-docs@arkaria.postgresql.org; Mon, 16 Dec 2019 11:15:51 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1igcUp-0001Os-Qi for pgsql-docs@lists.postgresql.org; Sun, 15 Dec 2019 22:36:15 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1igcUg-00083k-Py for pgsql-docs@lists.postgresql.org; Sun, 15 Dec 2019 22:36:15 +0000 Content-Type: multipart/mixed; boundary="===============1050095097235755924==" MIME-Version: 1.0 Subject: Re: Example 42.4. A PL/pgSQL Trigger Function for Auditing To: pgsql-docs@lists.postgresql.org From: PG Doc comments form Cc: simon.dallaway@datacom.co.nz Reply-To: simon.dallaway@datacom.co.nz, pgsql-docs@lists.postgresql.org Date: Sun, 15 Dec 2019 22:35:17 +0000 Message-ID: <157644931740.18138.16968232991166819127@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1050095097235755924== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBkb2N1bWVudGF0aW9uIGNvbW1lbnQgaGFzIGJlZW4gbG9nZ2VkIG9uIHRo ZSB3ZWJzaXRlOgoKUGFnZTogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xMi9wbHBn c3FsLXRyaWdnZXIuaHRtbApEZXNjcmlwdGlvbjoKCkknbSB3b25kZXJpbmcgaWYgaXQgd291bGQg YmUgd29ydGh3aGlsZSB0byBwdXQgYSB0b3RhbGx5IGdlbmVyaWMgYXVkaXRpbmcKZnVuY3Rpb24g aW50byB0aGUgZG9jdW1lbnRhdGlvbiBlLmcuDQoNCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9O IHp6X2F1ZGl0XygpIFJFVFVSTlMgVFJJR0dFUiBBUyAkbm90aGluZyQNCg0KLS0gVGhpcyBmdW5j dGlvbiBpcyBpbnRlbmRlZCB0byBiZSB1c2VkIGJ5IGEgZGVsZXRlL2luc2VydC91cGRhdGUgdHJp Z2dlcgpmb3IgYW55IHRhYmxlLg0KLS0gSXQgcmVsaWVzIG9uIHRoZSBleGlzdGVuY2Ugb2YgYSB0 YWJsZSBuYW1lZCB6el9hdWRpdF9YWFggKHdoZXJlIFhYWCBpcwp0aGUgdGFibGUgYmVpbmcgYXVk aXRlZCkgdGhhdCBjb250YWlucyB0aGUNCi0tIHNhbWUgY29sdW1ucyBhcyB0aGUgdGFibGUgWFhY IGV4Y2VwdCB0aGF0IHR3byBhZGRpdGlvbmFsIGNvbHVtbnMgbXVzdApleGlzdCBwcmlvciB0byB0 aGUgY29sdW1ucyBmcm9tIFhYWA0KLS0gICAgb3BlcmF0aW9uIGNoYXJhY3RlcigxKSBOT1QgTlVM TCwNCi0tICAgIHRzdGFtcCAgICB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUgTk9UIE5VTEwsDQot LSAgICAuLi4gICAgICAgcmVtYWluaW5nIGNvbHVtbnMgcGVyIHRhYmxlIFhYWA0KDQogICAgREVD TEFSRSBhdWRpdF90YWJsZV9uYW1lIE5BTUUgOj0gQ09OQ0FUKCd6el9hdWRpdF8nLCBUR19UQUJM RV9OQU1FKTsNCiAgICBCRUdJTg0KCQkNCiAgICAgICAgSUYgKFRHX09QID0gJ0RFTEVURScpIFRI RU4NCiAgICAgICAgICAgIEVYRUNVVEUgJ0lOU0VSVCBJTlRPICcgfHwgYXVkaXRfdGFibGVfbmFt ZSB8fCAnIFNFTEVDVCAnJ0QnJywKbm93KCksICcgfHwgJyAkMS4qJyBVU0lORyBPTEQ7DQogICAg ICAgIEVMU0lGIChUR19PUCA9ICdVUERBVEUnKSBUSEVODQoJCQlFWEVDVVRFICdJTlNFUlQgSU5U TyAnIHx8IGF1ZGl0X3RhYmxlX25hbWUgfHwgJyBTRUxFQ1QgJydVJycsIG5vdygpLCAnIHx8Cicg JDEuKicgVVNJTkcgTkVXOw0KICAgICAgICBFTFNJRiAoVEdfT1AgPSAnSU5TRVJUJykgVEhFTg0K CQkJRVhFQ1VURSAnSU5TRVJUIElOVE8gJyB8fCBhdWRpdF90YWJsZV9uYW1lIHx8ICcgU0VMRUNU ICcnSScnLCBub3coKSwgJyB8fAonICQxLionIFVTSU5HIE5FVzsNCiAgICAgICAgRU5EIElGOw0K DQogICAgICAgIFJFVFVSTiBOVUxMOyAtLSByZXN1bHQgaXMgaWdub3JlZCBzaW5jZSB0aGlzIGlz IGFuIEFGVEVSIHRyaWdnZXINCiAgICBFTkQ7DQokbm90aGluZyQgTEFOR1VBR0UgcGxwZ3NxbDsK --===============1050095097235755924==--