Re: Pasword expiration warning - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Pasword expiration warning
Date
Msg-id 4b380a18-42cc-4406-9484-efef10868f8c@eisentraut.org
Whole thread Raw
In response to Re: Pasword expiration warning  (Zsolt Parragi <zsolt.parragi@percona.com>)
List pgsql-hackers
On 04.02.26 18:44, Zsolt Parragi wrote:
>>> Alternatively, just print the actual expiration timestamp.
>>
>> That crossed my mind, but I worried about timezone/formatting questions,
>> and I haven't found any examples of putting a timestamp in an error message
>> like this. Is it acceptable to use pg_strftime() in a translated string?
> 
> Wouldn't that be more confusing?
> 
>    The password for role "foo" will expire at 2026-02-05 16:56"
> 
> No matter which date format is used, this is harder to understand than
> 
>    The password for role "foo" will expire in 1 day(s)
> 
> or
> 
>    The password for role "foo" will expire in 22 hour(s) 16 minute(s)
> 
> All 3 are about a password expiring around the same time plus minus a
> few hours, but the first one is significantly harder to figure out,
> first I have to think about what's the exact date today.

I would personally definitely prefer the first one.

I have also previously complained about the buildfarm showing relative 
instead of absolute timestamps, for similar reasons, but I was 
apparently also in the minority then.




pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible
Next
From: "Matheus Alcantara"
Date:
Subject: Re: Show expression of virtual columns in error messages