X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 01B25D1B4C3 for ; Thu, 4 Mar 2004 16:57:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 53402-02 for ; Thu, 4 Mar 2004 12:57:45 -0400 (AST) Received: from polaris.pinpointresearch.com (66-7-238-130.cust.telepacific.net [66.7.238.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8E44AD1CCC2 for ; Thu, 4 Mar 2004 12:57:43 -0400 (AST) Received: from betelgeuse.pinpointresearch.com (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id 7EBAC10400; Thu, 4 Mar 2004 08:57:39 -0800 (PST) From: Steve Crawford Organization: Pinpoint Research To: Tom Lane Subject: Re: bizarre AGE behaviour Date: Thu, 4 Mar 2004 08:57:39 -0800 User-Agent: KMail/1.5.1 Cc: DHS Webmaster , pgsql-admin References: <40461395.5324CFEE@dhs-club.com> <200403031000.05524.scrawford@pinpointresearch.com> <19029.1078355959@sss.pgh.pa.us> In-Reply-To: <19029.1078355959@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200403040857.39605.scrawford@pinpointresearch.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/23 X-Sequence-Number: 12593 On Wednesday 03 March 2004 3:19 pm, Tom Lane wrote: > Steve Crawford writes: > > US Daylight Saving Time starts this year on April 4 when 0200 > > jumps to 0300. The answers PostgreSQL gave are correct. > > I suspect what the OP wants is non-timezone-aware behavior... You are probably right. In his original post he posited that the problem was due to some sort of leap-year bug in PostgreSQL. I was just pointing him to the real cause of his observations so he could tackle whatever problem he was having secure in the knowledge that PG was working correctly. Cheers, Steve