Re: Prevent remote libpq notices from being sent to clients - Mailing list pgsql-hackers

From Chao Li
Subject Re: Prevent remote libpq notices from being sent to clients
Date
Msg-id 0F777DB5-9AC8-4414-A0DF-53F641B3E97E@gmail.com
Whole thread
In response to Re: Prevent remote libpq notices from being sent to clients  (Jacob Champion <jacob.champion@enterprisedb.com>)
List pgsql-hackers

> On Jun 5, 2026, at 23:20, Jacob Champion <jacob.champion@enterprisedb.com> wrote:
>
> On Fri, Jun 5, 2026 at 7:43 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Also, I don't buy the argument that this is a "leak": if the remote
>> server was willing to send the message to its client, it doesn't think
>> that the message is security-critical.
>
> I don't think the remote gets to decide that, in general. It's up to
> the middle layer to know whether it's operating at the same level of
> trust as the end client.
>
> --Jacob

Thanks to all for the input. It looks like people have different opinions on this topic. BTW, I realized that my
previouswording of "leak" was too strong, sorry about that. 

Here, I think the main concern is that this is an “unintentional" user-visible behavior change. I went through the
originaldiscussion thread [1], and I don't see this behavior change being explicitly discussed. I am not against
Fujii'sidea that emitting a remote WARNING to the client could be helpful, and I also like Tom's idea of mapping the
remoteseverity to the local log level. But if we really want to do that, I think we need a dedicated discussion, and
thatseems too late for v19. Also, if we eventually decide to change the client-visible behavior, I think we should
documentit explicitly. 

How about preserving the old client-visible behavior for v19?  I can add this topic to my TODO list and follow up with
thiswork for v20. 

[1] https://postgr.es/m/CALDaNm2xsHpWRtLm-VL_HJCsaE3+1Y_n-jDEAr3-suxVqc3xoQ@mail.gmail.com

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/







pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Re: Fix OAuth validator docs for error_detail on internal errors
Next
From: Evan
Date:
Subject: Re: [PATCH] Clarify that ssl_groups is for any key exchange groups