postgresql

History

Tom Lane 122d05e6b1 Update time zone data files to tzdata release 2011n. DST law changes in Brazil, Cuba, Fiji, Palestine, Russia, Samoa. Historical corrections for Alaska and British East Africa.		2011-11-30 11:49:21 -05:00
..
data	Update time zone data files to tzdata release 2011n.	2011-11-30 11:49:21 -05:00
tznames	Update time zone data files to tzdata release 2010l: DST law changes in	2010-08-26 19:59:15 +00:00
.gitignore	Convert cvsignore to gitignore, and add .gitignore for build targets.	2010-09-22 12:57:14 +02:00
Makefile	Arrange to install a "posixrules" entry in our timezone database, so that	2007-03-14 17:38:15 +00:00
README	Update docs to point to the timezone library's new home at IANA.	2011-10-27 23:09:30 -04:00
ialloc.c	Standard pgindent run for 8.1.	2005-10-15 02:49:52 +00:00
localtime.c	Fix up timetz input so that a date is required only when the specified	2006-10-18 16:43:14 +00:00
pgtz.c	Fix our mapping of Windows timezones for Central America.	2011-09-23 22:14:23 -04:00
pgtz.h	Arrange for timezone names to be recognized case-insensitively; for	2006-10-16 19:58:27 +00:00
private.h	Properly undef _(x) gettext macro.	2005-02-23 04:34:21 +00:00
scheck.c	Standard pgindent run for 8.1.	2005-10-15 02:49:52 +00:00
strftime.c	Remove 576 references of include files that were not needed.	2006-07-14 14:52:27 +00:00
tzfile.h	Standard pgindent run for 8.1.	2005-10-15 02:49:52 +00:00
zic.c	Tweak zic.c to compile cleanly on MSVC: use CopyFile instead of	2006-10-24 15:11:03 +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 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.