Vadim,
Actually you are correct, it is America/Montreal and now that I
switched it back it actually has useDaylight=true... very strange.
I think as John pointed out though there are some issues with using
named TimeZones.
Is there a way to get the servers timezone info from the server ?
Dave
On 20-Jul-05, at 3:10 PM, Vadim Nasardinov wrote:
> On Wednesday 20 July 2005 14:57, Dave Cramer wrote:
>
>> On my Mac my java timezone was set to Canada/Montreal which was
>> broken (did not use DST ) and the server certainly doesn't
>> understand it.
>>
>
> Out of curiosity, do you remember which JDK had this timezone?
> Sun's JDK on Linux doesn't have it:
>
> | $ find /usr/local/j2sdk1.4.2_08/jre/lib/zi/ -name Montreal
> | /usr/local/j2sdk1.4.2_08/jre/lib/zi/America/Montreal
>
> It only has America/Montreal, which PostgreSQL should grok just fine,
> AFAICT:
>
> | $ find /usr/share/zoneinfo/ -name Montreal
> | /usr/share/zoneinfo/right/America/Montreal
> | /usr/share/zoneinfo/posix/America/Montreal
> | /usr/share/zoneinfo/America/Montreal
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>