Re: ROLE VALID UNTIL timezone?

On 11/27/19 2:25 PM, Adrian Klaver wrote:
> On 11/27/19 2:19 PM, Ron wrote:
>> Hi,
>>
>> In 9.6, does it default to UTC, the postgresql.conf timezone value
>> (US/Eastern) value or to local system time?
>>
>>
>
> test_(postgres)# show timezone;
>   TimeZone
> ------------
>  US/Pacific
>
> test_(postgres)# create role ts_test valid until '12/31/2020';
> CREATE ROLE
>
> ts_test        | Cannot login   +| {}
>                 | Password valid until 2020-12-31 00:00:00-08      |
>
> Best guess it operates like if specifying a value for a timestamptz field.

Decided to see if guess was correct:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/backend/commands/user.c;h=aab5aa855d2851222dc7738c7575ad805f6bce94;hb=HEAD

Line 94

Datum validUntil_datum; /* same, as timestamptz Datum */

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com