Re: 2007 DST change not working

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(at)sss(dot)pgh(dot)pa(dot)us>tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>Frank Bax <<mailto:fbax(at)sympatico(dot)ca>fbax(at)sympatico(dot)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