On Wednesday 20 July 2005 14:16, Vadim Nasardinov wrote:
> Sun's JDK's timezone info seems fairly different from what, say,
> Fedora Core distributes in its tzdata RPM:
More precisely, Sun's timezone info seems to be a strict subset of
Fedora's timezone info. (This is for Sun's JDK 1.4.2_08 and Fedora
Core 3. I didn't bother to check JDK 1.5.0 -- it does add three
additional timezones over what was present in 1.4.2: America/Bahia,
America/Campo_Grande, and America/Toronto.)
I added a couple of "grep -v" pipes to filter out irrelevant
differences:
| $ find /usr/local/j2sdk1.4.2_08/jre/lib/zi -type f -printf '%P\n' | \
| grep -v ZoneInfoMappings | sort > /tmp/java-tzdata.txt
| $ find /usr/share/zoneinfo/ -type f -printf '%P\n' | \
| grep -v right/ | grep -vE '(right/|posix/|zone\.tab)' | \
| sort > /tmp/linux-tzdata.txt
This shows that the FC3 tzdata is a strict superset of the JDK 1.4.2
timezone info:
| $ diff /tmp/java-tzdata.txt /tmp/linux-tzdata.txt | grep -c '>'
| 152
| $ diff /tmp/java-tzdata.txt /tmp/linux-tzdata.txt | grep -c '<'
| 0
Whether or not this means that PostgreSQL on FC should be able to
handle any time zone that Java throws at it, I am not sure.