Re: [GENERAL] BST Time Zone Discrepancy

"Igal @ Lucee.org" <igal@lucee.org> writes:
> I've been having some issues with using BST as a timezone, so I checked
> the Postgres catalogs and found a discrepancy.
> ...
> But in pg_timezone_names I get an 11-hr offset with a completely
> different time zone.

> intranet=> SELECT * FROM pg_timezone_names WHERE abbrev='BST';
>              name            | abbrev | utc_offset | is_dst
> ----------------------------+--------+------------+--------
>   Pacific/Bougainville       | BST    | 11:00:00   | f
>   posix/Pacific/Bougainville | BST    | 11:00:00   | f
> (2 rows)

pg_timezone_names shows the *current* abbreviation for the zone in
question, so right now I get:

regression=# select * from pg_timezone_names where name like '%London';
        name         | abbrev | utc_offset | is_dst
---------------------+--------+------------+--------
 posix/Europe/London | GMT    | 00:00:00   | f
 Europe/London       | GMT    | 00:00:00   | f
(2 rows)

I don't see any particular problem here.  If you write 'BST' in an input
value, it will be understood as GMT+1, as you're expecting.

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)

            regards, tom lane