Re: Example 42.4. A PL/pgSQL Trigger Function for Auditing
PG Doc comments form <[email protected]> Sun, 15 Dec 2019 22:35:17 +0000
| Newsgroups | gmane.comp.db.postgresql.devel.documentation |
|---|---|
| Message-ID | <[email protected]> |
--===============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==--