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 1o8Sce-0007dD-5l for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Jul 2022 20:24:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o8Scd-00016D-10 for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Jul 2022 20:24:43 +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 1o8Scc-000164-Jx for pgsql-hackers@lists.postgresql.org; Mon, 04 Jul 2022 20:24:42 +0000 Received: from mail-pf1-x430.google.com ([2607:f8b0:4864:20::430]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1o8Sca-0001ko-8S for pgsql-hackers@postgresql.org; Mon, 04 Jul 2022 20:24:42 +0000 Received: by mail-pf1-x430.google.com with SMTP id 65so9749790pfw.11 for ; Mon, 04 Jul 2022 13:24:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:cc:date:in-reply-to:references :mime-version; bh=P365Gd5Q3qZk6a7dvoSZMPqzjjXWiPd6CqJ6pqWW22M=; b=Jmf9/Jdx12+6rR8YYkbGySrFqpIyJVOVfk/lzSUzZKlmcTJ5V5srHgsF/8alIO5++i 4Eoaw7j588JFyczignBmXAWUyC1rGTqAWqVC21oIT9NIfL4DZdOM3f0tGkeZE0cCkqcI SOcodYws14THmKDv9Rm5+Z+RE5//URxA3n7aYw5dqUmqZKBnWLh80LpGN55sQFwVm8tW a3qhaN28plLKAPKlVPOF+RXRf8VOebZFQEMArzy78FLBqoN4BBhHNbe9QBZIJvy/4l2v QKWlsOHWO52Xx3+rojbEPdPsgvqzpkpUjGQOPI8mp3sTd802lNyxsoJWXGXtR8+f3KZS 5RXg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:cc:date:in-reply-to :references:mime-version; bh=P365Gd5Q3qZk6a7dvoSZMPqzjjXWiPd6CqJ6pqWW22M=; b=1t68qDim+Ykg/iGvGPt38IvcE9BZHae5D/NDiq6pTj+3Kj/jXfihW8SJreYCaDxPeV TJjYNbirygqXF06bXfmeySGyUZt2570sioVeGYZFEj3nOqlnYnWUIU37TDrDNrFnDmbK oRMWSeZwqjLTGrJ83KwnhPS/6UPhxNfcu2mdcTrSMSDpD/taplcaLjUP5JFu5u8ls9hi ScrTUdI7CcRz/Oml8vZvX1sOmirmZcGJZD/1v8FaVDJhwRthALhdwVXKJFRYwBukIcca nErwmMLyQRk+R6RLKoJrXZd6NPkAEEe8/zFGB/0UJkNUTPqaXw6LGvliB22kNVyoFqR9 MPfQ== X-Gm-Message-State: AJIora83zY/ew6k2uCNXrHOPY9F2+dQvdNkWjXvPkIKw1RI1BlHkNzRR nTNt5vwGtJh9Cq3cIaGBZy5+Tw== X-Google-Smtp-Source: AGRyM1uhzvEvmlZsn4DS/pQHtS413Mo5AZXDjSdCWOXC1VmawwV15cQ5ln41Hj8fEDT/KorQg0jOjA== X-Received: by 2002:a05:6a00:2495:b0:525:a822:d732 with SMTP id c21-20020a056a00249500b00525a822d732mr37993766pfv.46.1656966277805; Mon, 04 Jul 2022 13:24:37 -0700 (PDT) Received: from jdavis.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id 8-20020aa79208000000b0050dc76281e0sm17130641pfo.186.2022.07.04.13.24.36 (version=TLS1_2 cipher=ECDHE-ECDSA-CHACHA20-POLY1305 bits=256/256); Mon, 04 Jul 2022 13:24:37 -0700 (PDT) Message-ID: <6afdaff716ea203519076dfd935d86af269acc2c.camel@j-davis.com> Subject: Re: Export log_line_prefix(); useful for emit_log_hook. From: Jeff Davis To: Michael Paquier , Alvaro Herrera Cc: pgsql-hackers@postgresql.org Date: Mon, 04 Jul 2022 13:24:36 -0700 In-Reply-To: References: <39c8197652f4d3050aedafae79fa5af31096505f.camel@j-davis.com> <20220629130942.dqac3h3746pjvauq@alvherre.pgsql> Content-Type: multipart/mixed; boundary="=-B6+dEdWjW128+AYad3Ji" X-Mailer: Evolution 3.28.5-0ubuntu0.18.04.2 Mime-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-B6+dEdWjW128+AYad3Ji Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit On Mon, 2022-07-04 at 15:54 +0900, Michael Paquier wrote: > On Wed, Jun 29, 2022 at 03:09:42PM +0200, Alvaro Herrera wrote: > > Hmm, maybe your hypothetical book would prefer to use a different > > setting for log line prefix than Log_line_prefix, so it would make > > sense > > to pass the format string as a parameter to the function instead of > > relying on the GUC global. That is nicer, attached. I also renamed the function log_status_format(), and made log_line_prefix() a thin wrapper over that. I think that's less confusing. Regards, Jeff Davis --=-B6+dEdWjW128+AYad3Ji Content-Disposition: attachment; filename*0=v2-0001-Provide-log_status_format-useful-for-an-emit_log_hoo.; filename*1=patch Content-Type: text/x-patch; name*0=v2-0001-Provide-log_status_format-useful-for-an-emit_log_hoo.patc; name*1=h; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSA0YzY0MDQ5ZTUwMGM4MGFjNDk1NzMyZDM0YWU1NmUwNzM5MzExNWZlIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKZWZmIERhdmlzIDxqZWZmQGotZGF2aXMuY29tPgpEYXRlOiBU dWUsIDI4IEp1biAyMDIyIDExOjM5OjMzIC0wNzAwClN1YmplY3Q6IFtQQVRDSF0gUHJvdmlkZSBs b2dfc3RhdHVzX2Zvcm1hdCgpLCB1c2VmdWwgZm9yIGFuIGVtaXRfbG9nX2hvb2suCgpSZWZhY3Rv ciBzbyB0aGF0IGxvZ19saW5lX3ByZWZpeCgpIGlzIGEgdGhpbiB3cmFwcGVyIG92ZXIgYSBuZXcK ZnVuY3Rpb24gbG9nX3N0YXR1c19mb3JtYXQoKSwgYW5kIG1vdmUgdGhlIGltcGxlbWVudGF0aW9u IHRvIHRoZQpsYXR0ZXIuIEV4cG9ydCBsb2dfc3RhdHVzX2Zvcm1hdCgpIHNvIHRoYXQgaXQgY2Fu IGJlIHVzZWQgYnkgYW4KZW1pdF9sb2dfaG9vay4KLS0tCiBzcmMvYmFja2VuZC91dGlscy9lcnJv ci9lbG9nLmMgfCAxNSArKysrKysrKysrKystLS0KIHNyYy9pbmNsdWRlL3V0aWxzL2Vsb2cuaCAg ICAgICB8ICAzICsrKwogMiBmaWxlcyBjaGFuZ2VkLCAxNSBpbnNlcnRpb25zKCspLCAzIGRlbGV0 aW9ucygtKQoKZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL3V0aWxzL2Vycm9yL2Vsb2cuYyBiL3Ny Yy9iYWNrZW5kL3V0aWxzL2Vycm9yL2Vsb2cuYwppbmRleCA1NWVlNTQyM2FmYi4uN2IyYmI5Yzhi NzUgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3V0aWxzL2Vycm9yL2Vsb2cuYworKysgYi9zcmMv YmFja2VuZC91dGlscy9lcnJvci9lbG9nLmMKQEAgLTI0MzksMTAgKzI0MzksMTkgQEAgcHJvY2Vz c19sb2dfcHJlZml4X3BhZGRpbmcoY29uc3QgY2hhciAqcCwgaW50ICpwcGFkZGluZykKIH0KIAog LyoKLSAqIEZvcm1hdCB0YWcgaW5mbyBmb3IgbG9nIGxpbmVzOyBhcHBlbmQgdG8gdGhlIHByb3Zp ZGVkIGJ1ZmZlci4KKyAqIEZvcm1hdCBsb2cgc3RhdHVzIGluZm9ybWF0aW9uIHVzaW5nIExvZ19s aW5lX3ByZWZpeC4KICAqLwogc3RhdGljIHZvaWQKIGxvZ19saW5lX3ByZWZpeChTdHJpbmdJbmZv IGJ1ZiwgRXJyb3JEYXRhICplZGF0YSkKK3sKKwlsb2dfc3RhdHVzX2Zvcm1hdChidWYsIExvZ19s aW5lX3ByZWZpeCwgZWRhdGEpOworfQorCisvKgorICogRm9ybWF0IGxvZyBzdGF0dXMgaW5mbzsg YXBwZW5kIHRvIHRoZSBwcm92aWRlZCBidWZmZXIuCisgKi8KK3ZvaWQKK2xvZ19zdGF0dXNfZm9y bWF0KFN0cmluZ0luZm8gYnVmLCBjaGFyICpmb3JtYXQsIEVycm9yRGF0YSAqZWRhdGEpCiB7CiAJ Lyogc3RhdGljIGNvdW50ZXIgZm9yIGxpbmUgbnVtYmVycyAqLwogCXN0YXRpYyBsb25nIGxvZ19s aW5lX251bWJlciA9IDA7CkBAIC0yNDY2LDEwICsyNDc1LDEwIEBAIGxvZ19saW5lX3ByZWZpeChT dHJpbmdJbmZvIGJ1ZiwgRXJyb3JEYXRhICplZGF0YSkKIAl9CiAJbG9nX2xpbmVfbnVtYmVyKys7 CiAKLQlpZiAoTG9nX2xpbmVfcHJlZml4ID09IE5VTEwpCisJaWYgKGZvcm1hdCA9PSBOVUxMKQog CQlyZXR1cm47CQkJCQkvKiBpbiBjYXNlIGd1YyBoYXNuJ3QgcnVuIHlldCAqLwogCi0JZm9yIChw ID0gTG9nX2xpbmVfcHJlZml4OyAqcCAhPSAnXDAnOyBwKyspCisJZm9yIChwID0gZm9ybWF0OyAq cCAhPSAnXDAnOyBwKyspCiAJewogCQlpZiAoKnAgIT0gJyUnKQogCQl7CmRpZmYgLS1naXQgYS9z cmMvaW5jbHVkZS91dGlscy9lbG9nLmggYi9zcmMvaW5jbHVkZS91dGlscy9lbG9nLmgKaW5kZXgg ZjVjNmNkOTA0ZGUuLmU4OGUzZjhhODAxIDEwMDY0NAotLS0gYS9zcmMvaW5jbHVkZS91dGlscy9l bG9nLmgKKysrIGIvc3JjL2luY2x1ZGUvdXRpbHMvZWxvZy5oCkBAIC0xNiw2ICsxNiw4IEBACiAK ICNpbmNsdWRlIDxzZXRqbXAuaD4KIAorI2luY2x1ZGUgImxpYi9zdHJpbmdpbmZvLmgiCisKIC8q IEVycm9yIGxldmVsIGNvZGVzICovCiAjZGVmaW5lIERFQlVHNQkJMTAJCQkvKiBEZWJ1Z2dpbmcg bWVzc2FnZXMsIGluIGNhdGVnb3JpZXMgb2YKIAkJCQkJCQkJICogZGVjcmVhc2luZyBkZXRhaWwu ICovCkBAIC00MzksNiArNDQxLDcgQEAgZXh0ZXJuIFBHRExMSU1QT1JUIGJvb2wgc3lzbG9nX3Nw bGl0X21lc3NhZ2VzOwogI2RlZmluZSBMT0dfREVTVElOQVRJT05fSlNPTkxPRwkxNgogCiAvKiBP dGhlciBleHBvcnRlZCBmdW5jdGlvbnMgKi8KK2V4dGVybiB2b2lkIGxvZ19zdGF0dXNfZm9ybWF0 KFN0cmluZ0luZm8gYnVmLCBjaGFyICpmb3JtYXQsIEVycm9yRGF0YSAqZWRhdGEpOwogZXh0ZXJu IHZvaWQgRGVidWdGaWxlT3Blbih2b2lkKTsKIGV4dGVybiBjaGFyICp1bnBhY2tfc3FsX3N0YXRl KGludCBzcWxfc3RhdGUpOwogZXh0ZXJuIGJvb2wgaW5fZXJyb3JfcmVjdXJzaW9uX3Ryb3VibGUo dm9pZCk7Ci0tIAoyLjE3LjEKCg== --=-B6+dEdWjW128+AYad3Ji--