postgresql/src/timezone
Tom Lane c51da696b4 Update time zone data files to tzdata release 2014e.
DST law changes in Crimea, Egypt, Morocco.  New zone Antarctica/Troll
for Norwegian base in Queen Maud Land.
2014-07-19 15:01:45 -04:00
..
data Update time zone data files to tzdata release 2014e. 2014-07-19 15:01:45 -04:00
tznames Update time zone data files to tzdata release 2013h. 2013-12-01 14:12:17 -05:00
.gitignore Convert cvsignore to gitignore, and add .gitignore for build targets. 2010-09-22 12:57:08 +02:00
Makefile Ooops, forgot to remove solar87 and friends from src/timezone/Makefile. 2014-02-14 23:20:33 -05:00
README Update docs to point to the timezone library's new home at IANA. 2011-10-27 23:09:21 -04:00
ialloc.c Update timezone code to track the upstream changes since 2003. In particular 2008-02-16 21:16:04 +00:00
known_abbrevs.txt Update time zone data files to tzdata release 2013h. 2013-12-01 14:12:17 -05:00
localtime.c Remove tabs after spaces in C comments 2014-05-06 11:26:24 -04:00
pgtz.c Remove tabs after spaces in C comments 2014-05-06 11:26:24 -04:00
pgtz.h 8.4 pgindent run, with new combined Linux/FreeBSD/MinGW typedef list 2009-06-11 14:49:15 +00:00
private.h 8.4 pgindent run, with new combined Linux/FreeBSD/MinGW typedef list 2009-06-11 14:49:15 +00:00
scheck.c Update timezone code to track the upstream changes since 2003. In particular 2008-02-16 21:16:04 +00:00
strftime.c Sync timezone code with tzcode 2010c from the Olson group. This fixes some 2010-03-11 18:43:32 +00:00
tzfile.h 8.4 pgindent run, with new combined Linux/FreeBSD/MinGW typedef list 2009-06-11 14:49:15 +00:00
zic.c Sync timezone code with tzcode 2010c from the Olson group. This fixes some 2010-03-11 18:43:32 +00:00

README

src/timezone/README

Timezone
========

This is a PostgreSQL adapted version of the timezone library from
http://www.iana.org/time-zones

The source code can be found at:

	ftp://ftp.iana.org/tz/releases/tzcode*.tar.gz

The code is currently synced with release 2010c.  There are many cosmetic
(and not so cosmetic) differences from the original tzcode library, but
diffs in the upstream version should usually be propagated to our version.

The data files under data/ are an exact copy of the latest data set from:

	ftp://ftp.iana.org/tz/releases/tzdata*.tar.gz

Since time zone rules change frequently in some parts of the world,
we should endeavor to update the data files before each PostgreSQL
release.

At each update, we should check if time zone offsets have changed.
Just search for the current or previous year and see what has changed.
Sometimes a country changes its time zone offsets, for example Georgia
in 2004.  Just grepping in the zic database files for 2004 is enough to
spot such a change.  Then the files under tznames/ should be updated.