Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 342579FB410 for ; Tue, 30 Jan 2007 18:05:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 63861-06 for ; Tue, 30 Jan 2007 18:05:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr2.hagander.net (svr2.hagander.net [88.198.128.226]) by postgresql.org (Postfix) with ESMTP id 5C9009FB2FC for ; Tue, 30 Jan 2007 18:05:19 -0400 (AST) Received: from svr2.hagander.net (svr2.hagander.net [88.198.128.226]) by svr2.hagander.net (Postfix) with ESMTP id EE250DCC2E9; Tue, 30 Jan 2007 23:05:17 +0100 (CET) Received: by svr2.hagander.net (Postfix, from userid 1000) id E6DFFDCC2EA; Tue, 30 Jan 2007 23:05:17 +0100 (CET) Date: Tue, 30 Jan 2007 23:05:17 +0100 From: Magnus Hagander To: Match.Grun@thomson.com Cc: pgsql-ports@postgresql.org, bruce@momjian.us Subject: Re: Daylight Saving Time Message-ID: <20070130220517.GJ21930@svr2.hagander.net> References: <4AAF1740D046264BAD7CF21F81BADE5A03B1FCA0@tshuscodenmbx01.ERF.THOMSON.COM> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4AAF1740D046264BAD7CF21F81BADE5A03B1FCA0@tshuscodenmbx01.ERF.THOMSON.COM> User-Agent: Mutt/1.5.11 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/7 X-Sequence-Number: 2515 On Tue, Jan 30, 2007 at 02:21:21PM -0700, Match.Grun@thomson.com wrote: > As you may know, DST in the US has been changed from 2007. On March 11 > we begin DST. > > I have searched the Postgres site, but there is no reference to > potential issues that may be caused by this. Also, since the Solaris > port built with the Sun Compiler did have an issue with a Horology test > case, maybe the PORTS team have most experience with this issue? I beleive you are safe as long as you are on the latest versoins - you'll need 8.2.1, 8.1.6 or 8.0.10. Bruce - given that the actual change-time is coming up, how about we add this one to the FAQ? If it isn't now, it's bound to become. > Does anyone know how this would affect the following ports: > > Sun GCC > Windows MINGW > Linux GCC All affected the same way. If you're using a < 8.0 version, postgresql uses the operating systems timezone functions, so you'll have to look at the documentation for your OS. //Magnus