Re: DST failing on 8.1.3 - Mailing list pgsql-general

On Wed, 2007-03-14 at 11:16 -0400, Jaime Silvela wrote:
> I'm running a production database on Linux (select version() =
> "PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3")
> I read that all 8.1.* versions are DST-compliant, and sure enough, my
> development server, which runs 8.1.0, switched fine, as did my 8.2.3
> database at home.
> The production database was upgraded a while ago to 8.1.3 from 7.*. I'm
> ready to upgrade to 8.2.3 to get the the benefit of all the development
> since then, but before doing that I'd like to find out what's the
> problem with the DST not taking.
>
> The timezone is 'EST5EDT', and
>
> SELECT CASE WHEN
>   timestamptz '20070401 0100'
>   + interval '1 hour'
>   >= '20070401 0300'
>   THEN 'Wrong' ELSE 'Right' END;
>
> returns 'Wrong'.
>

That should have been wrong.

1+1=2 not 3 or more

EST5EDT change is :
2nd Sunday of March @02:00:00 +01:00:00
 and
1st Sunday of November @02:00:00 -01:00:00

Were you not aware that your current President legislated the
changes to Daylight Savings. As a result most of North and South
America has had to legislate the changes to alleviate what
could only have been chaos figuring out what the time would be
in different parts of the Americas.


> Are there perhaps timezone definition files that may not have been added
> when upgrading from 7.*?
>
> Thanks
> Jaime
>
>
> ***********************************************************************
> Bear Stearns is not responsible for any recommendation, solicitation,
> offer or agreement or any information about any transaction, customer
> account or account activity contained in this communication.
>
> Bear Stearns does not provide tax, legal or accounting advice.  You
> should consult your own tax, legal and accounting advisors before
> engaging in any transaction. In order for Bear Stearns to comply with
> Internal Revenue Service Circular 230 (if applicable), you are notified
> that any discussion of U.S. federal tax issues contained or referred to
> herein is not intended or written to be used, and cannot be used, for
> the purpose of:  (A) avoiding penalties that may be imposed under the
> Internal Revenue Code; nor (B) promoting, marketing or recommending to
> another party any transaction or matter addressed herein.
> ***********************************************************************
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>
--
Guy Fraser
Network Administrator
The Internet Centre
1-888-450-6787
(780)450-6787