From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | "Igal (at) Lucee(dot)org" <igal(at)lucee(dot)org> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: BST Time Zone Discrepancy |
Date: | 2017-02-06 21:11:47 |
Message-ID: | 3280d2d1-e070-9c58-e31c-433d0ec6f626@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/06/2017 12:44 PM, Igal @ Lucee.org wrote:
> Tom,
>
> Thank you for your reply:
>
> On 2/6/2017 12:18 PM, Tom Lane wrote:
>> This is controlled by the timezone_abbreviations file, which if
>> you haven't changed it lists:
>>
>> # CONFLICT! BST is not unique
>> # Other timezones:
>> # - BST: Bougainville Standard Time (Papua New Guinea)
>> BST 3600 D # British Summer Time
>> # (Europe/London)
> I haven't changed any of the config files. I can not find that file on
> my system (maybe it's in the source code only).
timezone_abbreviations is actually a setting in postgresql.conf. The
file Tom is referring to is the file that setting points to, by default
that is Default. This is a file in the Postgres share/timezonesets
directory. A do not use RH so I am not sure where that directory lives.
>
> I am using the Red Hat distribution: PostgreSQL 9.6.1 on
> x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
> 4.8.5-4), 64-bit
>
>> pg_timezone_names shows the *current* abbreviation for the zone in question
> I'm not sure what you mean by "current". If this is not an issue then
> that's fine, you can ignore this message. It just seemed weird to me
> that pg_timezone_names and pg_timezone_abbrevs showed very different
> results for the same code.
>
> Thanks,
>
> Igal Sapir
> Lucee Core Developer
> Lucee.org <http://lucee.org/>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Igal @ Lucee.org | 2017-02-06 21:16:40 | Re: BST Time Zone Discrepancy |
Previous Message | Steve Crawford | 2017-02-06 21:08:26 | Re: BST Time Zone Discrepancy |