From: | Kumar Harsh <khs(at)playlyfe(dot)com> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | The default timezone is being shown as UCT instead of UTC |
Date: | 2019-06-04 08:37:06 |
Message-ID: | CAM8Q7gPjK+ePM0FBQP=wLZp4RsK1JEJmA9ZaFm4peyfB58yVCQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Package: postgresql-11
Version: 11.3.1
The postgres system has the default timezone set to 'UCT'
instead of 'UTC'. This bug was introduced in version 9.6.12,
and hasn't been fixed as of the latest stable version (11.3.1).
Reproducible example:
Run psql, and then:
psql (11.3 (Debian 11.3-1.pgdg90+1))
Type "help" for help.
postgres=# show timezone;
show timezone;
-[ RECORD 1 ]-
TimeZone | UCT
This issue was originally reported already in the
Github docker repository here:
https://github.com/docker-library/postgres/issues/577
I suggest that the default timezone be made 'UTC' like it was
before (and like is expected).
I am running the postgres server insider a docker container
on Windows Subsystem for Linux, but this happens in other
pure debian linux systems too.
*Please see the Github issue linked above for more details.*
Regards
Harsh
From | Date | Subject | |
---|---|---|---|
Next Message | Ashutosh Sharma | 2019-06-04 09:19:48 | Re: BUG #15832: COPY into a partitioned table breaks its indexes |
Previous Message | PG Bug reporting form | 2019-06-04 04:41:55 | BUG #15832: COPY into a partitioned table breaks its indexes |