I've been having some issues with using BST as a timezone, so I
checked the Postgres catalogs and found a discrepancy. I expected it to be British Summer Time, which is a Daylight Saving Time in England and has a 1-hour UTC offset. In pg_timezone_abbrevs I see a 1-hr offset and is_dst set to true
as I expected: intranet=> SELECT * FROM pg_timezone_abbrevs WHERE
abbrev='BST'; 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'; Surely, they can not both be right, so I'm thinking that this is
a bug? Thank you, --
Igal Sapir
|