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 1p8gvX-00013c-7G for pgsql-docs@arkaria.postgresql.org; Fri, 23 Dec 2022 12:13:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p8guY-0002uV-53 for pgsql-docs@arkaria.postgresql.org; Fri, 23 Dec 2022 12:12:26 +0000 Received: from makus.postgresql.org ([72.32.157.229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p8guX-0002uM-PC for pgsql-docs@lists.postgresql.org; Fri, 23 Dec 2022 12:12:25 +0000 Received: from mail-ej1-x62c.google.com ([2a00:1450:4864:20::62c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p8gsP-00082p-Gp for pgsql-docs@lists.postgresql.org; Fri, 23 Dec 2022 12:10:14 +0000 Received: by mail-ej1-x62c.google.com with SMTP id qk9so11674364ejc.3 for ; Fri, 23 Dec 2022 04:10:13 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=/1/XR1EtXH0wsh3VB4kCrgf1ctHFWnGI3L3/YVF/BAQ=; b=t+ZQfYiwu7RCMUnOZuZ/5SpPrQ6qzDYN34tR/PT58t+Yo7H+Vku9u1EACO15oh2dXp eBLUB00Tebrux/D2E/MPKnguSr0FBzVCTb1w4HkT1vGog+PaMGqRza8KDsY1EnVqyqJR cVBn1/FWubw/f5nrkPmJOCDSD+FqZRKfwv7Kr0b9XPFzzvPjU7sGEIPY1B0ZQn6zJTv/ i7tr9C3R4nvd+/wEd1Y9KfZYM2N5jMRNoSLimSGNpT+W449y2ochR4N2n92mTRkfPSaL 98UtJFm1fwf4DhOptvbUBc11m1F/cF7jDO0tWI7S1tSZqt3gFZTY+99jntJh37LoP9Jm 4yDA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:user-agent:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=/1/XR1EtXH0wsh3VB4kCrgf1ctHFWnGI3L3/YVF/BAQ=; b=S0R0bErqAmzlv+fN7zsLQtwcoTzcIu6FbFbULucFxShJZo3MNsA0yKt96UYbG+O8yd xgqTc4spR4SXShNLCECPaiGNT6fwDF3rW2NZ6lSaBBaRaFopMKPi2NKzlSnLsiVPXd9P YWCcua2xmAtveP60gTXE9bkwgTIvjGhi2PKsx5QhZgbGtkjmOVnwjFA5foQLuyXYOoNs S+OOcsDmomAww/6uA+zkt1qgXcDrbhQalut6qnawTVWg45GjDULJBCCT4b5lN0sx94dl EZhOIhcmeMQtUItg4DWLVyTdrn94flqwBge3JcJVsezxHyP0kTw+fGVr9eW4eZ+JsDo2 qg+g== X-Gm-Message-State: AFqh2krw+r39OxJFQ/Gn13LuQcB9NoUAPTizZVdeVfoPz/CWI3cWsZTS OWOtcJclE8e68pkbSO+gjLsRA1BeS/poh7J/ X-Google-Smtp-Source: AMrXdXvzRU0ExOFz75oDkJw1keTeZSEHb/lqtMjcxmPPlNQ2avWStLwOCFKYQHUGZGXKqQYchDPfMg== X-Received: by 2002:a17:906:8e91:b0:7c1:5248:4f3a with SMTP id ru17-20020a1709068e9100b007c152484f3amr7864125ejc.56.1671797411598; Fri, 23 Dec 2022 04:10:11 -0800 (PST) Received: from localhost.localdomain (62-47-151-123.adsl.highway.telekom.at. [62.47.151.123]) by smtp.gmail.com with ESMTPSA id vf20-20020a170907239400b0081586470b7csm1340022ejb.173.2022.12.23.04.10.11 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 23 Dec 2022 04:10:11 -0800 (PST) Message-ID: <81e36ac17dc80489e74dc5b6914afa6ccdb1a99d.camel@cybertec.at> Subject: Fix broken event trigger example From: Laurenz Albe To: pgsql-docs@lists.postgresql.org Date: Fri, 23 Dec 2022 13:10:10 +0100 Content-Type: multipart/mixed; boundary="=-cIBRukFE3tAWmlSwk61P" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-cIBRukFE3tAWmlSwk61P Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit The example in https://www.postgresql.org/docs/current/event-trigger-example.html stopped compiling since commit 2f9661311b. Here is a patch to fix that. Yours, Laurenz Albe --=-cIBRukFE3tAWmlSwk61P Content-Disposition: attachment; filename="0001-Fix-event-trigger-example.patch" Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="0001-Fix-event-trigger-example.patch"; charset="UTF-8" RnJvbSBhZTBhYThkMDFkZjA2MjZhMDQxN2M2YzMzOWY1OWVlNTBkZTVjMmIzIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogRnJpLCAyMyBEZWMgMjAyMiAxMzowNzoyNSArMDEwMApTdWJqZWN0OiBbUEFUQ0hd IEZpeCBldmVudCB0cmlnZ2VyIGV4YW1wbGUKCkNvbW1pdCAyZjk2NjEzMTFiIGNoYW5nZWQgY29t bWFuZCB0YWdzIGZyb20gc3RyaW5ncyB0byBudW1iZXJzLApidXQgZm9yZ290IHRvIGFkanVzdCB0 aGUgY29kZSBpbiB0aGUgZXZlbnQgdHJpZ2dlciBleGFtcGxlLAp3aGljaCBjb25zZXF1ZW50bHkg ZmFpbGVkIHRvIGNvbXBpbGUuCgpXaGlsZSBmaXhpbmcgdGhhdCwgaW1wcm92ZSB0aGUgaW5kZW50 YXRpb24gdG8gYWRoZXJlIHRvIHBnaW5kZW50CnN0eWxlLgoKQmFja3BhdGNoIHRvIHYxMywgd2hl cmUgdGhlIGNoYW5nZSB3YXMgaW50cm9kdWNlZC4KCkF1dGhvcjogTGF1cmVueiBBbGJlCi0tLQog ZG9jL3NyYy9zZ21sL2V2ZW50LXRyaWdnZXIuc2dtbCB8IDUgKysrLS0KIDEgZmlsZSBjaGFuZ2Vk LCAzIGluc2VydGlvbnMoKyksIDIgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9z Z21sL2V2ZW50LXRyaWdnZXIuc2dtbCBiL2RvYy9zcmMvc2dtbC9ldmVudC10cmlnZ2VyLnNnbWwK aW5kZXggZjEyMzVhMmM5Zi4uM2I2YTUzNjFiMyAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL2V2 ZW50LXRyaWdnZXIuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvZXZlbnQtdHJpZ2dlci5zZ21sCkBA IC0xMTk0LDggKzExOTQsOSBAQCBub2RkbChQR19GVU5DVElPTl9BUkdTKQogICAgIHRyaWdkYXRh ID0gKEV2ZW50VHJpZ2dlckRhdGEgKikgZmNpbmZvLT5jb250ZXh0OwogCiAgICAgZXJlcG9ydChF UlJPUiwKLSAgICAgICAgKGVycmNvZGUoRVJSQ09ERV9JTlNVRkZJQ0lFTlRfUFJJVklMRUdFKSwK LSAgICAgICAgICAgICAgICAgZXJybXNnKCJjb21tYW5kIFwiJXNcIiBkZW5pZWQiLCB0cmlnZGF0 YS0+dGFnKSkpOworICAgICAgICAgICAgKGVycmNvZGUoRVJSQ09ERV9JTlNVRkZJQ0lFTlRfUFJJ VklMRUdFKSwKKyAgICAgICAgICAgICBlcnJtc2coImNvbW1hbmQgXCIlc1wiIGRlbmllZCIsCisg ICAgICAgICAgICAgICAgICAgIEdldENvbW1hbmRUYWdOYW1lKHRyaWdkYXRhLT50YWcpKSkpOwog CiAgICAgUEdfUkVUVVJOX05VTEwoKTsKIH0KLS0gCjIuMzguMQoK --=-cIBRukFE3tAWmlSwk61P--