Re: Pasword expiration warning

On Fri, 09 Jan 2026 at 14:10, Yuefei Shi <shiyuefei1004(at)gmail(dot)com> wrote:
> A few review comments for V8.
>
> ===
> 1.
> + if (password_expire_warning > 0 && vuntil < PG_INT64_MAX)
> + {
> + TimestampTz result = (vuntil - now) / USECS_PER_SEC; /* in seconds */
> +
> + if (result <= (TimestampTz) password_expire_warning)
> + MyClientConnectionInfo.warning_message =
> + psprintf("your password will expire in %d day(s)", (int) (result / 86400));
> + }
> Please consider localization of the warning message.
>
> 2. typo fix
> a. `Controls how many time ...` should be `Controls how much time ...`.
> b. `Sets how many time before password expire to emit ...` should be `Sets how much time before password expires to emit ...`

Nice catch. Updated in v9. Please take to look.

I've also replaced the magic constant 86400 with the SECS_PER_DAY macro and
enclosed the statement in braces since it now spans multiple lines.

--
Regards,
Japin Li
ChengDu WenWu Information Technology Co., Ltd.