timezone change not in changelog ?

From: Laurent Laborde <kerdezixe(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: timezone change not in changelog ?
Date: 2012-10-17 11:49:14
Message-ID: CAEy3c_S0aYYWhHOko7cC8Qmh7u2ROpqH8nzJVFtcvCV81ejTQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Friendly greetings !
There is a change between 9.1 and 9.2 that doesn't seems to be in the
changelog :
http://www.postgresql.org/docs/9.2/static/runtime-config-client.html#GUC-TIMEZONE
http://www.postgresql.org/docs/9.1/static/runtime-config-client.html#GUC-TIMEZONE

* in 9.1 the default timezone is the system timezone :
timezone (string)
Sets the time zone for displaying and interpreting time stamps. If not
explicitly set, the server initializes this variable to the time zone
specified by its system environment. See Section 8.5.3 for more
information.

* in 9.2 the default timezone is GMT :
TimeZone (string)
Sets the time zone for displaying and interpreting time stamps. The
built-in default is GMT, but that is typically overridden in
postgresql.conf; initdb will install a setting there corresponding to
its system environment. See Section 8.5.3 for more information.

--
Laurent "ker2x" Laborde
Sysadmin & DBA at http://www.over-blog.com/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message P. Christeas 2012-10-17 12:38:41 [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows
Previous Message Amit Kapila 2012-10-17 11:46:04 Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown