BUG #6637: Casablanca timezone is wrong

Started by David Chuetalmost 14 years ago3 messagesbugs
Jump to latest
#1David Chuet
dchuet@odotech.com

The following bug has been logged on the website:

Bug reference: 6637
Logged by: David Chuet
Email address: dchuet@odotech.com
PostgreSQL version: 9.0.7
Operating system: Windows 7 x64
Description:

Using Postgresql command :

------------------------------------------
SELECT * FROM pg_timezone_names
------------------------------------------
We get for Africa/Casablanca, timezone equal to WET with no DST.

This is not true from 2010.
See Wikipedia, for Morocco:

Time zone WET (UTC+0)
Summer (DST) WEST (UTC+1)(May 2nd to August 7th)

So, I cannot set correctly the DateTime for an install in Morocco.

#2Robert Haas
robertmhaas@gmail.com
In reply to: David Chuet (#1)
Re: BUG #6637: Casablanca timezone is wrong

On Mon, May 14, 2012 at 11:08 AM, <dchuet@odotech.com> wrote:

The following bug has been logged on the website:

Bug reference:      6637
Logged by:          David Chuet
Email address:      dchuet@odotech.com
PostgreSQL version: 9.0.7
Operating system:   Windows 7 x64
Description:

Using Postgresql command :

------------------------------------------
SELECT * FROM pg_timezone_names
------------------------------------------
We get for Africa/Casablanca, timezone equal to WET with no DST.

This is not true from 2010.
See Wikipedia, for Morocco:

Time zone       WET (UTC+0)
Summer (DST)    WEST (UTC+1)(May 2nd to August 7th)

So, I cannot set correctly the DateTime for an install in Morocco.

We get the time zone list from the operating system. It might not be
working correctly, but based on this amount of information I can't
speculate as to why.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

#3Robert Haas
robertmhaas@gmail.com
In reply to: Robert Haas (#2)
Re: BUG #6637: Casablanca timezone is wrong

On Tue, May 22, 2012 at 3:46 PM, Robert Haas <robertmhaas@gmail.com> wrote:

On Mon, May 14, 2012 at 11:08 AM,  <dchuet@odotech.com> wrote:

The following bug has been logged on the website:

Bug reference:      6637
Logged by:          David Chuet
Email address:      dchuet@odotech.com
PostgreSQL version: 9.0.7
Operating system:   Windows 7 x64
Description:

Using Postgresql command :

------------------------------------------
SELECT * FROM pg_timezone_names
------------------------------------------
We get for Africa/Casablanca, timezone equal to WET with no DST.

This is not true from 2010.
See Wikipedia, for Morocco:

Time zone       WET (UTC+0)
Summer (DST)    WEST (UTC+1)(May 2nd to August 7th)

So, I cannot set correctly the DateTime for an install in Morocco.

We get the time zone list from the operating system.  It might not be
working correctly, but based on this amount of information I can't
speculate as to why.

And of course now I see that (1) someone already replied to your
reposting of this bug and (2) what I just told you was completely
wrong.

Sorry for the noise.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company