Thread: BUG #6637: Casablanca timezone is wrong
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:=20=20=20=20=20=20=20=20 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.
On Mon, May 14, 2012 at 11:08 AM, <dchuet@odotech.com> wrote: > The following bug has been logged on the website: > > Bug reference: =A0 =A0 =A06637 > Logged by: =A0 =A0 =A0 =A0 =A0David Chuet > Email address: =A0 =A0 =A0dchuet@odotech.com > PostgreSQL version: 9.0.7 > Operating system: =A0 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 =A0 =A0 =A0 WET (UTC+0) > Summer (DST) =A0 =A0WEST (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. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Tue, May 22, 2012 at 3:46 PM, Robert Haas <robertmhaas@gmail.com> wrote: > On Mon, May 14, 2012 at 11:08 AM, =A0<dchuet@odotech.com> wrote: >> The following bug has been logged on the website: >> >> Bug reference: =A0 =A0 =A06637 >> Logged by: =A0 =A0 =A0 =A0 =A0David Chuet >> Email address: =A0 =A0 =A0dchuet@odotech.com >> PostgreSQL version: 9.0.7 >> Operating system: =A0 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 =A0 =A0 =A0 WET (UTC+0) >> Summer (DST) =A0 =A0WEST (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. =A0It 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. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company