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