Re: 2007 DST change not working - Mailing list pgsql-novice

I still haven't found the zone files on my system.  The file I dumped in a
previous message was from OS ( At the time, I thought it was the same thing).

I think I'll do the "US/Eastern" work around for now.  I notice that I must
reload tables for this work correctly (or did I miss something)?  I'm still
testing upgrade from 7.3.5 to 8.1.5, so reoad is not a problem this time.

I used to install from source about 5 years ago; but now I've been spoiled
by binary packages from OpenBSD.  They have 8.1.5, but not yet 8.2
available yet.



At 07:00 PM 1/1/07, Chad Wagner wrote:

>Frank,
>Of course you could always get brave and recompile the zone files :).  I
>outlined a procedure on my web site:
>
><http://www.postgresqlforums.com/wiki/>http://www.postgresqlforums.com/wiki/
>
>If your interested in braving those waters.  I did perform it against
>8.1.5 and the zone files worked fine with your test case.
>
>Perhaps this is a good excuse to give 8.2 a whirl?  :)
>
>On 1/1/07, Tom Lane <<mailto:tgl@sss.pgh.pa.us>tgl@sss.pgh.pa.us> wrote:
>>Frank Bax <<mailto:fbax@sympatico.ca>fbax@sympatico.ca> writes:
>> > fbax=>  show time zone;
>> >      TimeZone
>> > ----------------
>> >   Canada/Eastern
>>
>>Oh, there's your problem: as of 8.1.5's version of the zoneinfo files,
>>it wasn't clear what Canada was going to do.  Looking at our CVS history
>>it seems the zoneinfo people only did something about it in mid-2006:
>>
>>+# From Paul Eggert (2006-06-27):
>>+# For now, assume all of DST-observing Canada will fall into line with the
>>+# new US DST rules,
>>
>>This is in CVS for 8.1.6 but not released yet.  What I'd suggest is
>>grabbing the share/timezone/* files out of an 8.2.0 release, which
>>does have the update.  You might be able to get away with just copying
>>your /usr/share/zoneinfo tree into Postgres' share/timezone directory,
>>but be prepared to undo that because it could break things entirely:
>>there's more than one zoneinfo file format out there.
>>
>>Also note you need to restart the postmaster after updating zoneinfo,
>>I don't think there's any provision for noticing updates automatically.
>>
>>                         regards, tom lane
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 9: In versions below 8.0, the planner will ignore your desire to
>>        choose an index scan if your joining column's datatypes do not
>>        match