Feedback-ID: i0c21471d:Fastmail
MIME-Version: 1.0
Date: Tue, 10 Feb 2026 19:05:30 -0300
From: "Euler Taveira" <euler@eulerto.com>
To: "Alvaro Herrera" <alvherre@alvh.no-ip.org>
Cc: japin <japinli@hotmail.com>, "Andres Freund" <andres@anarazel.de>,
 pgsql-hackers@lists.postgresql.org, "Chao Li" <li.evan.chao@gmail.com>
Message-Id: <39c31ea3-489d-4333-9275-abf763acd71c@app.fastmail.com>
In-Reply-To: <202602091301.qogmz6asejuy@alvherre.pgsql>
References: <202602091301.qogmz6asejuy@alvherre.pgsql>
Subject: Re: log_min_messages per backend type
Content-Type: multipart/mixed;
 boundary=efcba764d33f41f38777d41234a0ad00
Archived-At: <https://www.postgresql.org/message-id/39c31ea3-489d-4333-9275-abf763acd71c%40app.fastmail.com>
Precedence: bulk

--efcba764d33f41f38777d41234a0ad00
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Mon, Feb 9, 2026, at 10:03 AM, Alvaro Herrera wrote:
> On 2026-Feb-09, Alvaro Herrera wrote:
>
>> I just pushed this, and somehow I forgot to squash this into the commit.
>> I don't think it matters terribly much though, so I'm going to hang onto
>> this for a while in case some bug is found.
>
> Euler mentioned offlist that I also forgot to remove
> log_min_messages_process_types from guc.h.  So that gives us this patch
> for now.
>

I expanded this patch a bit with fixes proposed by Man Zeng and Noriyoshi
Shinoda. Besides these changes, I noticed that

* default value in uppercase: since we changed the vartype from enum to string
  and enum maps DEBUG1 to "debug1" (see server_message_level_options), it
  should use the lowercase string to keep the same output as previous versions.
  There is no bug here. It is just a matter of keeping the same output.
* use single quote: since we changed the vartype from enum to string, we should
  add single quotes. If you don't add single quotes, it works (for a single
  default log level) -- as exercised in the tests. However, as soon as the user
  adds an extra element it fails. This avoids confusion.

$ psql
psql (19devel)
Type "help" for help.

postgres=# show log_min_messages;
 log_min_messages 
------------------
 WARNING
(1 row)

postgres=# set log_min_messages to debug1;
SET
postgres=# show log_min_messages;
 log_min_messages 
------------------
 debug1
(1 row)

postgres=# set log_min_messages to 'debug1';
SET
postgres=# show log_min_messages;
 log_min_messages 
------------------
 debug1
(1 row)

postgres=# set log_min_messages to warning, backend:error;
ERROR:  syntax error at or near ":"
LINE 1: set log_min_messages to warning, backend:error;
                                                ^
postgres=# set log_min_messages to 'warning, backend:error';
SET
postgres=# show log_min_messages;
    log_min_messages    
------------------------
 warning, backend:error
(1 row)


-- 
Euler Taveira
EDB   https://www.enterprisedb.com/
--efcba764d33f41f38777d41234a0ad00
Content-Disposition: attachment;
	filename*0="0001-Minor-cleanups-in-log_min_messages.patch"
Content-Type: text/x-patch;
	name="=?UTF-8?Q?0001-Minor-cleanups-in-log=5Fmin=5Fmessages.patch?="
Content-Transfer-Encoding: base64

RnJvbSBhOTk4NDcxOGJlZDhmMmZkN2U2YmEzYzA5NmEwNzM0OTk0OGEwNTk4IE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBFdWxlciBUYXZlaXJhIDxldWxlckBldWxlcnRvLmNv
bT4KRGF0ZTogVHVlLCAxMCBGZWIgMjAyNiAxMTozOTo1NiAtMDMwMApTdWJqZWN0OiBbUEFU
Q0hdIE1pbm9yIGNsZWFudXBzIGluIGxvZ19taW5fbWVzc2FnZXMKCkZpeCBzb21lIGlzc3Vl
cyBpbiBjb21taXQgMzhlMDE5MGNlZDcuIFJlbW92ZSBhbiB1bnVzZWQgdmFyaWFibGUuIFVz
ZQoiZGVmYXVsdCBsb2cgbGV2ZWwiIGNvbnNpc3RlbnRseS4gS2VlcCB0aGUgcHJvY2VzcyB0
eXBlcyBpbiBhbHBoYWJldGljYWwKb3JkZXIuICBTaW5jZSBsb2dfbWluX21lc3NhZ2VzIHR5
cGUgd2FzIGNoYW5nZWQgZnJvbSBlbnVtIHRvIHN0cmluZywgaXQKaXMgYSBnb29kIGlkZWEg
dG8gdXNlIHNpbmdsZSBxdW90ZXMuIEFsdGhvdWdoIGl0IHdvcmtzIGZvciBhIHNpbmdsZQpk
ZWZhdWx0IGxvZyBsZXZlbCwgaXQgd2lsbCBmYWlsIGFzIHNvb24gYXMgdGhlIHVzZXIgdHJp
ZXMgdG8gYWRkIGFuCmV4dHJhIGVsZW1lbnQgdG8gdGhlIHZhbHVlLiBVc2luZyBzaW5nbGUg
cXVvdGVzIG1pbmltaXplcyB0aGUgY2hhbmNlIG9mCmNvbmZ1c2lvbi4gVXNlIGxvd2VyY2Fz
ZSBzdHJpbmcgZm9yIHRoZSBkZWZhdWx0IHZhbHVlIHRvIGtlZXAgdGhlIHNhbWUKb3V0cHV0
IGFzIHByZXZpb3VzIHZlcnNpb25zLgotLS0KIGRvYy9zcmMvc2dtbC9jb25maWcuc2dtbCAg
ICAgICAgICAgICAgICAgICAgICB8ICAyICstCiBzcmMvYmFja2VuZC91dGlscy9lcnJvci9l
bG9nLmMgICAgICAgICAgICAgICAgfCAxNCArKysrKysrLS0tLS0tLQogc3JjL2JhY2tlbmQv
dXRpbHMvbWlzYy9ndWNfcGFyYW1ldGVycy5kYXQgICAgIHwgIDIgKy0KIHNyYy9iYWNrZW5k
L3V0aWxzL21pc2MvcG9zdGdyZXNxbC5jb25mLnNhbXBsZSB8ICAyICstCiBzcmMvaW5jbHVk
ZS9wb3N0bWFzdGVyL3Byb2N0eXBlbGlzdC5oICAgICAgICAgfCAgMiArLQogc3JjL2luY2x1
ZGUvdXRpbHMvZ3VjLmggICAgICAgICAgICAgICAgICAgICAgIHwgIDIgLS0KIDYgZmlsZXMg
Y2hhbmdlZCwgMTEgaW5zZXJ0aW9ucygrKSwgMTMgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0
IGEvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21sIGIvZG9jL3NyYy9zZ21sL2NvbmZpZy5zZ21s
CmluZGV4IDM3MzQyOTg2OTY5Li42MWQzOWZkMzM2NiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9z
Z21sL2NvbmZpZy5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9jb25maWcuc2dtbApAQCAtNzE0
NSw5ICs3MTQ1LDkgQEAgbG9jYWwwLiogICAgL3Zhci9sb2cvcG9zdGdyZXNxbAogICAgICAg
ICAgPG1lbWJlcj48bGl0ZXJhbD5jaGVja3BvaW50ZXI8L2xpdGVyYWw+PC9tZW1iZXI+CiAg
ICAgICAgICA8bWVtYmVyPjxsaXRlcmFsPmlvd29ya2VyPC9saXRlcmFsPjwvbWVtYmVyPgog
ICAgICAgICAgPG1lbWJlcj48bGl0ZXJhbD5wb3N0bWFzdGVyPC9saXRlcmFsPjwvbWVtYmVy
PgotICAgICAgICAgPG1lbWJlcj48bGl0ZXJhbD5zeXNsb2dnZXI8L2xpdGVyYWw+PC9tZW1i
ZXI+CiAgICAgICAgICA8bWVtYmVyPjxsaXRlcmFsPnNsb3RzeW5jd29ya2VyPC9saXRlcmFs
PjwvbWVtYmVyPgogICAgICAgICAgPG1lbWJlcj48bGl0ZXJhbD5zdGFydHVwPC9saXRlcmFs
PjwvbWVtYmVyPgorICAgICAgICAgPG1lbWJlcj48bGl0ZXJhbD5zeXNsb2dnZXI8L2xpdGVy
YWw+PC9tZW1iZXI+CiAgICAgICAgICA8bWVtYmVyPjxsaXRlcmFsPndhbHJlY2VpdmVyPC9s
aXRlcmFsPjwvbWVtYmVyPgogICAgICAgICAgPG1lbWJlcj48bGl0ZXJhbD53YWxzZW5kZXI8
L2xpdGVyYWw+PC9tZW1iZXI+CiAgICAgICAgICA8bWVtYmVyPjxsaXRlcmFsPndhbHN1bW1h
cml6ZXI8L2xpdGVyYWw+PC9tZW1iZXI+CmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC91dGls
cy9lcnJvci9lbG9nLmMgYi9zcmMvYmFja2VuZC91dGlscy9lcnJvci9lbG9nLmMKaW5kZXgg
MTI5OTA2ZTJkYWEuLjU5MzE1ZTk0ZTNlIDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC91dGls
cy9lcnJvci9lbG9nLmMKKysrIGIvc3JjL2JhY2tlbmQvdXRpbHMvZXJyb3IvZWxvZy5jCkBA
IC0yMTkwLDcgKzIxOTAsNyBAQCBjaGVja19sb2dfbWluX21lc3NhZ2VzKGNoYXIgKipuZXd2
YWwsIHZvaWQgKipleHRyYSwgR3VjU291cmNlIHNvdXJjZSkKIAljaGFyCSAgICpyZXN1bHQ7
CiAJaW50CQkJbmV3bGV2ZWxbQkFDS0VORF9OVU1fVFlQRVNdOwogCWJvb2wJCWFzc2lnbmVk
W0JBQ0tFTkRfTlVNX1RZUEVTXSA9IHswfTsKLQlpbnQJCQlnZW5lcmljbGV2ZWwgPSAtMTsJ
LyogLTEgbWVhbnMgbm90IGFzc2lnbmVkICovCisJaW50CQkJZGVmYXVsdGxldmVsID0gLTE7
CS8qIC0xIG1lYW5zIG5vdCBhc3NpZ25lZCAqLwogCiAJY29uc3QgY2hhciAqY29uc3QgcHJv
Y2Vzc190eXBlc1tdID0gewogI2RlZmluZSBQR19QUk9DVFlQRShia3R5cGUsIGJrY2F0ZWdv
cnksIGRlc2NyaXB0aW9uLCBtYWluX2Z1bmMsIHNobWVtX2F0dGFjaCkgXApAQCAtMjIyOCw4
ICsyMjI4LDggQEAgY2hlY2tfbG9nX21pbl9tZXNzYWdlcyhjaGFyICoqbmV3dmFsLCB2b2lk
ICoqZXh0cmEsIEd1Y1NvdXJjZSBzb3VyY2UpCiAJCQljb25zdCBzdHJ1Y3QgY29uZmlnX2Vu
dW1fZW50cnkgKmVudHJ5OwogCQkJYm9vbAkJZm91bmQ7CiAKLQkJCS8qIFJlamVjdCBkdXBs
aWNhdGVzIGZvciBnZW5lcmljIGxvZyBsZXZlbC4gKi8KLQkJCWlmIChnZW5lcmljbGV2ZWwg
IT0gLTEpCisJCQkvKiBSZWplY3QgZHVwbGljYXRlcyBmb3IgZGVmYXVsdCBsb2cgbGV2ZWwu
ICovCisJCQlpZiAoZGVmYXVsdGxldmVsICE9IC0xKQogCQkJewogCQkJCUdVQ19jaGVja19l
cnJkZXRhaWwoIlJlZHVuZGFudCBzcGVjaWZpY2F0aW9uIG9mIGRlZmF1bHQgbG9nIGxldmVs
LiIpOwogCQkJCWdvdG8gbG1tX2ZhaWw7CkBAIC0yMjQxLDcgKzIyNDEsNyBAQCBjaGVja19s
b2dfbWluX21lc3NhZ2VzKGNoYXIgKipuZXd2YWwsIHZvaWQgKipleHRyYSwgR3VjU291cmNl
IHNvdXJjZSkKIAkJCXsKIAkJCQlpZiAocGdfc3RyY2FzZWNtcChlbnRyeS0+bmFtZSwgZWxl
bSkgPT0gMCkKIAkJCQl7Ci0JCQkJCWdlbmVyaWNsZXZlbCA9IGVudHJ5LT52YWw7CisJCQkJ
CWRlZmF1bHRsZXZlbCA9IGVudHJ5LT52YWw7CiAJCQkJCWZvdW5kID0gdHJ1ZTsKIAkJCQkJ
YnJlYWs7CiAJCQkJfQpAQCAtMjMzMSw5ICsyMzMxLDkgQEAgbG1tX2ZhaWw6CiAJfQogCiAJ
LyoKLQkgKiBUaGUgZ2VuZXJpYyBsb2cgbGV2ZWwgbXVzdCBiZSBzcGVjaWZpZWQuIEl0IGlz
IHRoZSBmYWxsYmFjayB2YWx1ZS4KKwkgKiBUaGUgZGVmYXVsdCBsb2cgbGV2ZWwgbXVzdCBi
ZSBzcGVjaWZpZWQuIEl0IGlzIHRoZSBmYWxsYmFjayB2YWx1ZS4KIAkgKi8KLQlpZiAoZ2Vu
ZXJpY2xldmVsID09IC0xKQorCWlmIChkZWZhdWx0bGV2ZWwgPT0gLTEpCiAJewogCQlHVUNf
Y2hlY2tfZXJyZGV0YWlsKCJEZWZhdWx0IGxvZyBsZXZlbCB3YXMgbm90IGRlZmluZWQuIik7
CiAJCWd1Y19mcmVlKHJhd3N0cmluZyk7CkBAIC0yMzQ1LDcgKzIzNDUsNyBAQCBsbW1fZmFp
bDoKIAlmb3IgKGludCBpID0gMDsgaSA8IEJBQ0tFTkRfTlVNX1RZUEVTOyBpKyspCiAJewog
CQlpZiAoIWFzc2lnbmVkW2ldKQotCQkJbmV3bGV2ZWxbaV0gPSBnZW5lcmljbGV2ZWw7CisJ
CQluZXdsZXZlbFtpXSA9IGRlZmF1bHRsZXZlbDsKIAl9CiAKIAkvKgpkaWZmIC0tZ2l0IGEv
c3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9ndWNfcGFyYW1ldGVycy5kYXQgYi9zcmMvYmFja2Vu
ZC91dGlscy9taXNjL2d1Y19wYXJhbWV0ZXJzLmRhdAppbmRleCA3NjJiOGVmZTZiMC4uNGI4
YmQ1N2QxZTcgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3V0aWxzL21pc2MvZ3VjX3BhcmFt
ZXRlcnMuZGF0CisrKyBiL3NyYy9iYWNrZW5kL3V0aWxzL21pc2MvZ3VjX3BhcmFtZXRlcnMu
ZGF0CkBAIC0xNjk4LDcgKzE2OTgsNyBAQAogICBsb25nX2Rlc2MgPT4gJ0VhY2ggbGV2ZWwg
aW5jbHVkZXMgYWxsIHRoZSBsZXZlbHMgdGhhdCBmb2xsb3cgaXQuIFRoZSBsYXRlciB0aGUg
bGV2ZWwsIHRoZSBmZXdlciBtZXNzYWdlcyBhcmUgc2VudC4nLAogICBmbGFncyA9PiAnR1VD
X0xJU1RfSU5QVVQnLAogICB2YXJpYWJsZSA9PiAnbG9nX21pbl9tZXNzYWdlc19zdHJpbmcn
LAotICBib290X3ZhbCA9PiAnIldBUk5JTkciJywKKyAgYm9vdF92YWwgPT4gJyJ3YXJuaW5n
IicsCiAgIGNoZWNrX2hvb2sgPT4gJ2NoZWNrX2xvZ19taW5fbWVzc2FnZXMnLAogICBhc3Np
Z25faG9vayA9PiAnYXNzaWduX2xvZ19taW5fbWVzc2FnZXMnLAogfSwKZGlmZiAtLWdpdCBh
L3NyYy9iYWNrZW5kL3V0aWxzL21pc2MvcG9zdGdyZXNxbC5jb25mLnNhbXBsZSBiL3NyYy9i
YWNrZW5kL3V0aWxzL21pc2MvcG9zdGdyZXNxbC5jb25mLnNhbXBsZQppbmRleCA2ZTgyYzhl
MDU1ZC4uMTIxODNmNjk5NmYgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL3V0aWxzL21pc2Mv
cG9zdGdyZXNxbC5jb25mLnNhbXBsZQorKysgYi9zcmMvYmFja2VuZC91dGlscy9taXNjL3Bv
c3RncmVzcWwuY29uZi5zYW1wbGUKQEAgLTUzMiw3ICs1MzIsNyBAQAogCiAjIC0gV2hlbiB0
byBMb2cgLQogCi0jbG9nX21pbl9tZXNzYWdlcyA9IHdhcm5pbmcgICAgICAgICAgICAgIyBj
b21tYS1zZXBhcmF0ZWQgbGlzdCBvZgorI2xvZ19taW5fbWVzc2FnZXMgPSAnd2FybmluZycg
ICAgICAgICAgICMgY29tbWEtc2VwYXJhdGVkIGxpc3Qgb2YKICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAjIHByb2Nlc3NfdHlwZTpsZXZlbCBlbnRyaWVzLCBw
bHVzCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIyBvbmUgZnJl
ZXN0YW5kaW5nIGxldmVsIGFzIGRlZmF1bHQuCiAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgIyBWYWxpZCBwcm9jZXNzIHR5cGVzIGFyZToKZGlmZiAtLWdpdCBh
L3NyYy9pbmNsdWRlL3Bvc3RtYXN0ZXIvcHJvY3R5cGVsaXN0LmggYi9zcmMvaW5jbHVkZS9w
b3N0bWFzdGVyL3Byb2N0eXBlbGlzdC5oCmluZGV4IDRlMjU5ZTg0YzJkLi5mZWFjMTliYTIw
NyAxMDA2NDQKLS0tIGEvc3JjL2luY2x1ZGUvcG9zdG1hc3Rlci9wcm9jdHlwZWxpc3QuaAor
KysgYi9zcmMvaW5jbHVkZS9wb3N0bWFzdGVyL3Byb2N0eXBlbGlzdC5oCkBAIC0yNiw3ICsy
Niw3IEBACiAKIC8qCiAgKiBMaXN0IG9mIHByb2Nlc3MgdHlwZXMgKHN5bWJvbCwgY2F0ZWdv
cnksIGRlc2NyaXB0aW9uLCBNYWluIGZ1bmN0aW9uLAotICogc2htZW1fYXR0YWNoLCBtZXNz
YWdlIGxldmVsKSBlbnRyaWVzLgorICogc2htZW1fYXR0YWNoKSBlbnRyaWVzLgogICovCiAK
IApkaWZmIC0tZ2l0IGEvc3JjL2luY2x1ZGUvdXRpbHMvZ3VjLmggYi9zcmMvaW5jbHVkZS91
dGlscy9ndWMuaAppbmRleCA4YWNiZGJhN2ZmNS4uYzQ2MjAzZmFiZmUgMTAwNjQ0Ci0tLSBh
L3NyYy9pbmNsdWRlL3V0aWxzL2d1Yy5oCisrKyBiL3NyYy9pbmNsdWRlL3V0aWxzL2d1Yy5o
CkBAIC0zMjksOCArMzI5LDYgQEAgZXh0ZXJuIFBHRExMSU1QT1JUIGJvb2wgdHJhY2Vfc29y
dDsKIGV4dGVybiBQR0RMTElNUE9SVCBib29sIG9wdGltaXplX2JvdW5kZWRfc29ydDsKICNl
bmRpZgogCi1leHRlcm4gUEdETExJTVBPUlQgY29uc3QgY2hhciAqY29uc3QgbG9nX21pbl9t
ZXNzYWdlc19wcm9jZXNzX3R5cGVzW107Ci0KIC8qCiAgKiBEZWNsYXJhdGlvbnMgZm9yIG9w
dGlvbnMgZm9yIGVudW0gdmFsdWVzCiAgKgotLSAKMi4zOS41Cgo=

--efcba764d33f41f38777d41234a0ad00--