summaryrefslogtreecommitdiff
path: root/src/timezone
AgeCommit message (Collapse)Author
2009-12-09Update time zone data files to tzdata release 2009s: DST law changes inTom Lane
Antarctica, Argentina, Bangladesh, Fiji, Novokuznetsk, Pakistan, Palestine, Samoa, Syria. Also historical corrections for Hong Kong.
2009-10-03Fix a couple of issues in recent patch to print updates to postgresql.confTom Lane
settings: avoid calling superuser() in contexts where it's not defined, don't leak the transient copies of GetConfigOption output, and avoid the whole exercise in postmaster child processes. I found that actually no current caller of GetConfigOption has any use for its internal check of GUC_SUPERUSER_ONLY. But rather than just remove that entirely, it seemed better to add a parameter indicating whether to enforce the check. Per report from Simon and subsequent testing.
2009-09-06Update the tznames reference files, and add IDT (Israel Daylight Time)Tom Lane
to the Default timezone abbreviation set. Back-port the the current file set to all branches that contain tznames. This includes adding SGT to the Default set in pre-8.4 releases. Joachim Wieland
2009-09-03Update time zone data files to tzdata release 2009l: DST law changes inTom Lane
Egypt, Mauritius, Bangladesh.
2009-08-26Update of install-sh, mkinstalldirs, and associated configuryPeter Eisentraut
Update install-sh to that from Autoconf 2.63, plus our Darwin-specific changes (which I simplified a bit). install-sh is now able to install multiple files in one run, so we could simplify our makefiles sometime. install-sh also now has a -d option to create directories, so we don't need mkinstalldirs anymore. Use AC_PROG_MKDIR_P in configure.in, so we can use mkdir -p when available instead of install-sh -d. For consistency with the rest of the world, the corresponding make variable has been renamed from $(mkinstalldirs) to $(MKDIR_P).
2009-06-11Update time zone data files to tzdata release 2009i: DST law changes inTom Lane
Bangladesh, Egypt, Jordan, Pakistan.
2009-06-118.4 pgindent run, with new combined Linux/FreeBSD/MinGW typedef listBruce Momjian
provided by Andrew.
2009-04-09Update time zone data files to tzdata release 2009e: DST law changes inTom Lane
Argentina/San_Luis, Cuba, Jordan (historical correction only), Morocco, Palestine, Syria, Tunisia.
2009-03-05Add MUST (Mauritius Island Summer Time) to the list of known abbreviations.Heikki Linnakangas
Mauritius began using DST in the summer 2008-2009; the Olson library has been updated already. Xavier Bugaud
2009-01-29Update time zone data files to tzdata release 2009a: introduces Asia/KathmanduTom Lane
as the preferred spelling of that zone name, corrects historical DST information for Switzerland and Cuba.
2009-01-06Fix new timezone cross-compile rule to avoid a bug in gmake 3.78.1;Bruce Momjian
document change.
2009-01-05When cross-compiling, allow and require an external zic program to be usedPeter Eisentraut
when --with-system-tzdata is not used. initial patch by Richard Evans
2009-01-01Update copyright for 2009.Bruce Momjian
2008-11-13Suppress leap-second-aware timezones in the output of pg_tzenumerate_next,Tom Lane
and thereby in the pg_timezone_names view. Although we allow such zones to be used in certain limited contexts like AT TIME ZONE, we don't allow them in SET TIME ZONE, and bug #4528 shows that they're more likely to confuse users than do anything useful. So hide 'em. (Note that we don't even generate these zones when installing our own timezone database. But they are likely to be present when using a system-provided database.)
2008-10-30Update time zone data files to tzdata release 2008i (DST law changes inTom Lane
Argentina, Brazil, Mauritius, Syria).
2008-09-17Update time zone data files to tzdata release 2008f (DST law changes inTom Lane
Argentina, Bahamas, Brazil, Mauritius, Morocco, Pakistan, Palestine, Paraguay).
2008-07-01Fix identify_system_timezone() so that it tests the behavior of the systemTom Lane
timezone setting in the current year and for 100 years back, rather than always examining years 1904-2004. The original coding would have problems distinguishing zones whose behavior diverged only after 2004; which is a situation we will surely face sometime, if it's not out there already. In passing, also prevent selection of the dummy "Factory" timezone, even if that's exactly what the system is using. Reporting time as GMT seems better than that.
2008-06-01Update time zone data files to tzdata release 2008c (DST law changes inTom Lane
Morocco, Iraq, Choibalsan, Pakistan, Syria, Cuba, Argentina/San_Luis).
2008-05-01Add SGT (Singapore time) to the default list of known timezoneTom Lane
abbreviations. It doesn't conflict with any other abbreviation so there seems no reason not to include it. Per a recent gripe.
2008-03-21More README src cleanups.Bruce Momjian
2008-03-13Update to tzdata 2008a distribution (Chilean DST law change).Tom Lane
2008-03-02Venezuela Time now means UTC-4:30, not UTC-4:00. Adjust our treatmentTom Lane
of "VET" accordingly. Per bug #3997 from Aaron Mizrachi.
2008-02-19More refactoring, so that the SUBSYS.o rules are now all in one place.Peter Eisentraut
2008-02-19Fix function prototype to silence compiler warnings.Magnus Hagander
2008-02-16Update timezone code to track the upstream changes since 2003. In particularTom Lane
this adds support for 64-bit tzdata files, which is needed to support DST calculations beyond 2038. Add a regression test case to give some minimal confidence that that really works. Heikki Linnakangas
2008-02-11Update timezone mapping for Windows with new timezones addedMagnus Hagander
in windows servicepacks. Fix timezone mapping for "Mexico 2"
2008-01-02Insert ARST into the list of known timezone abbreviations.Tom Lane
2008-01-01Update time zone data files to tzdata release 2007k.Tom Lane
2008-01-01Update copyrights in source tree to 2008.Bruce Momjian
2007-11-15Re-run pgindent with updated list of typedefs. (Updated README shouldBruce Momjian
avoid this problem in the future.)
2007-11-15Update timezone data files to release 2007i of the zic database.Tom Lane
2007-11-15pgindent run for 8.3.Bruce Momjian
2007-10-26Avoid including any backend-only stuff in the zic utility program.Tom Lane
Per gripe from Zdenek Kotala, though not exactly his patch.
2007-10-04Update timezone data files to release 2007h of the zic database.Tom Lane
Might as well have the latest when we wrap 8.3beta1.
2007-09-11Sync timezone data with 2007g zic release.Tom Lane
2007-08-25Adjust with-system-tzdata patch to not attempt to install a symlink,Tom Lane
but just hardwire the specified timezone database path into the executable. Per discussion, this avoids some packaging disadvantages of using a symlink.
2007-08-20Add configure option --with-system-tzdata to use operating system time zonePeter Eisentraut
database.
2007-08-04Fix crash caused by log_timezone patch if we attempt to emit any elog messagesTom Lane
between the setting of log_line_prefix and the setting of log_timezone. We can't realistically set log_timezone any earlier than we do now, so the best behavior seems to be to use GMT zone if any timestamps are to be logged during early startup. Create a dummy zone variable with a minimal definition of GMT (in particular it will never know about leap seconds), so that we can set it up without reference to any external files.
2007-08-04Switch over to using the src/timezone functions for formatting timestampsTom Lane
displayed in the postmaster log. This avoids Windows-specific problems with localized time zone names that are in the wrong encoding, and generally seems like a good idea to forestall other potential platform-dependent issues. To preserve the existing behavior that all backends will log in the same time zone, create a new GUC variable log_timezone that can only be changed on a system-wide basis, and reference log-related calculations to that zone instead of the TimeZone variable. This fixes the issue reported by Hiroshi Saito that timestamps printed by xlog.c startup could be improperly localized on Windows. We still need a simpler patch for that problem in the back branches, however.
2007-05-31Make some messages more consistentPeter Eisentraut
2007-04-19Sync timezone data with 2007e zic release.Tom Lane
2007-03-14Arrange to install a "posixrules" entry in our timezone database, so thatTom Lane
POSIX-style timezone specs that don't exactly match any database entry will be treated as having correct USA DST rules. Also, document that this can be changed if you want to use some other DST rules with a POSIX zone spec. We could consider changing localtime.c's TZDEFRULESTRING, but since that facility can only deal with one DST transition rule, it seems fairly useless now; might as well just plan to override it using a "posixrules" entry. Backpatch as far as 8.0. There isn't much we can do in 7.x ... either your libc gets it right, or it doesn't.
2007-02-10StrNCpy -> strlcpy (not complete)Peter Eisentraut
2007-02-09Replace useless uses of := by = in makefiles.Peter Eisentraut
2007-02-01Wording cleanup for error messages. Also change can't -> cannot.Bruce Momjian
Standard English uses "may", "can", and "might" in different ways: may - permission, "You may borrow my rake." can - ability, "I can lift that log." might - possibility, "It might rain today." Unfortunately, in conversational English, their use is often mixed, as in, "You may use this variable to do X", when in fact, "can" is a better choice. Similarly, "It may crash" is better stated, "It might crash".
2007-01-26Squelch some VC++ compiler warnings. Mark float literals with the "f"Neil Conway
suffix, to distinguish them from doubles. Make some function declarations and definitions use the "const" qualifier for arguments consistently. Ignore warning 4102 ("unreferenced label"), because such warnings are always emitted by bison-generated code. Patch from Magnus Hagander.
2007-01-05Update CVS HEAD for 2007 copyright. Back branches are typically notBruce Momjian
back-stamped for this.
2006-12-15Put JST back into the default set of timezone abbreviations;Tom Lane
was removed in an unexplainable moment of brain fade.
2006-11-28Update timezone data to tzdata2006p zic distribution. It seems WesternTom Lane
Australia decided to institute DST with one month's notice ... way to go, politicians.
2006-11-21Translate Windows' GMT Standard Time/GMT Daylight Time zones toTom Lane
zic's Europe/London, rather than Europe/Dublin as before. This seems a less surprising choice, particularly with respect to dates before 1948. Original suggestion was to translate to straight GMT, but this seems wrong given that these zones *are* DST-aware. Per offlist discussion with Magnus.