~ubuntu-branches/ubuntu/precise/postgresql-8.4/precise

Viewing changes to src/timezone/data/southamerica

Committer: Bazaar Package Importer
Author(s): Martin Pitt
Date: 2011-04-20 16:10:45 UTC
mfrom: (1.3.2 upstream)
Revision ID: james.westby@ubuntu.com-20110420161045-nrk3s2t0szvn2o80

Tags: 8.4.8-0ubuntu0.11.04

http://bugs.debian.org/616180

* New upstream bug fix release: (LP: #767165)
  - If your installation was upgraded from a previous major release by
    running pg_upgrade, you should take action to prevent possible data loss
    due to a now-fixed bug in pg_upgrade. The recommended solution is to run
    "VACUUM FREEZE" on all TOAST tables.  More information is available at
    http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix.
  - Fix pg_upgrade's handling of TOAST tables.
    This error poses a significant risk of data loss for installations
    that have been upgraded with pg_upgrade. This patch corrects the
    problem for future uses of pg_upgrade, but does not in itself cure
    the issue in installations that have been processed with a buggy
    version of pg_upgrade.
  - Suppress incorrect "PD_ALL_VISIBLE flag was incorrectly set"
    warning.
  - Disallow including a composite type in itself.
  - Avoid potential deadlock during catalog cache initialization.
  - Fix dangling-pointer problem in BEFORE ROW UPDATE trigger handling
    when there was a concurrent update to the target tuple.
  - Disallow "DROP TABLE" when there are pending deferred trigger
    events for the table.
    Formerly the "DROP" would go through, leading to "could not open
    relation with OID nnn" errors when the triggers were eventually
    fired.
  - Prevent crash triggered by constant-false WHERE conditions during
    GEQO optimization.
  - Improve planner's handling of semi-join and anti-join cases.
  - Fix selectivity estimation for text search to account for NULLs.
  - Improve PL/pgSQL's ability to handle row types with dropped columns.
  - Fix PL/Python memory leak involving array slices.
  - Fix pg_restore to cope with long lines (over 1KB) in TOC files.
  - Put in more safeguards against crashing due to division-by-zero
    with overly enthusiastic compiler optimization. (Closes: #616180)

files added:
src/backend/access/common/tupconvert.c

src/include/access/tupconvert.h

files modified:
HISTORY

INSTALL

configure

configure.in

debian/changelog

debian/control

doc/bug.template

doc/man.tar.gz

doc/postgres.tar.gz

doc/src/sgml/ref/create_user_mapping.sgml

doc/src/sgml/release-8.2.sgml

doc/src/sgml/release-8.3.sgml

doc/src/sgml/release-8.4.sgml

doc/src/sgml/start.sgml

doc/src/sgml/xaggr.sgml

src/backend/access/common/Makefile

src/backend/catalog/heap.c

src/backend/catalog/index.c

src/backend/commands/tablecmds.c

src/backend/commands/trigger.c

src/backend/commands/vacuumlazy.c

src/backend/executor/execMain.c

src/backend/executor/execQual.c

src/backend/optimizer/path/joinrels.c

src/backend/optimizer/prep/prepjointree.c

src/backend/po/de.po

src/backend/po/es.po

src/backend/po/fr.po

src/backend/port/dynloader/freebsd.c

src/backend/port/dynloader/netbsd.c

src/backend/port/dynloader/openbsd.c

src/backend/storage/ipc/procarray.c

src/backend/tcop/postgres.c

src/backend/tsearch/ts_selfuncs.c

src/backend/utils/adt/arrayfuncs.c

src/backend/utils/adt/int.c

src/backend/utils/adt/int8.c

src/backend/utils/adt/selfuncs.c

src/backend/utils/cache/catcache.c

src/backend/utils/cache/relcache.c

src/bin/pg_dump/pg_backup_archiver.c

src/bin/pg_dump/pg_dump.c

src/bin/pg_dump/pg_dump.h

src/include/catalog/heap.h

src/include/catalog/pg_statistic.h

src/include/commands/trigger.h

src/include/pg_config.h.win32

src/include/port.h

src/interfaces/ecpg/test/expected/sql-fetch.stderr

src/interfaces/libpq/libpq-dist.rc

src/interfaces/libpq/libpq.rc.in

src/pl/plpgsql/src/nls.mk

src/pl/plpgsql/src/pl_exec.c

src/pl/plpython/plpython.c

src/port/win32ver.rc

src/test/regress/expected/alter_table.out

src/test/regress/expected/plpgsql.out

src/test/regress/pg_regress.c

src/test/regress/sql/alter_table.sql

src/test/regress/sql/plpgsql.sql

src/timezone/data/africa

src/timezone/data/asia

src/timezone/data/australasia

src/timezone/data/etcetera

src/timezone/data/europe

src/timezone/data/leapseconds

src/timezone/data/northamerica

src/timezone/data/southamerica

src/timezone/data/zone.tab

src/tools/msvc/Install.pm

Show diffs side-by-side

added added

removed removed

src/timezone/data/southamerica

# <pre>

# @(#)southamerica 8.44

# @(#)southamerica 8.48

# This file is in the public domain, so clarified as of

# 2009-05-17 by Arthur David Olson.

1154

# From Arthur Daivd Olson (2010-03-06):

1155

# Angel Chiang's message confirmed by Julio Pacheco; Julio provided a patch.

1156

1157

# From Glenn Eychaner (2011-03-02): [geychaner@mac.com]

1158

# It appears that the Chilean government has decided to postpone the

1159

# change from summer time to winter time again, by three weeks to April

1160

# 2nd:

1161

# <a href="http://www.emol.com/noticias/nacional/detalle/detallenoticias.asp?idnoticia=467651">

1162

# http://www.emol.com/noticias/nacional/detalle/detallenoticias.asp?idnoticia=467651

1163

# </a>

1164

1165

# This is not yet reflected in the offical "cambio de hora" site, but

1166

# probably will be soon:

1167

# <a href="http://www.horaoficial.cl/cambio.htm">

1168

# http://www.horaoficial.cl/cambio.htm

1169

# </a>

1170

1171

# From Arthur David Olson (2011-03-02):

1172

# The emol.com article mentions a water shortage as the cause of the

1173

# postponement, which may mean that it's not a permanent change.

1174

1175

# From Glenn Eychaner (2011-03-28):

1176

# The article:

1177

# <a href="http://diario.elmercurio.com/2011/03/28/_portada/_portada/noticias/7565897A-CA86-49E6-9E03-660B21A4883E.htm?id=3D{7565897A-CA86-49E6-9E03-660B21A4883E}">

1178

# http://diario.elmercurio.com/2011/03/28/_portada/_portada/noticias/7565897A-CA86-49E6-9E03-660B21A4883E.htm?id=3D{7565897A-CA86-49E6-9E03-660B21A4883E}

1179

# </a>

1180

1181

# In English:

1182

# Chile's clocks will go back an hour this year on the 7th of May instead

1183

# of this Saturday. They will go forward again the 3rd Saturday in

1184

# August, not in October as they have since 1968. This is a pilot plan

1185

# which will be reevaluated in 2012.

1186

1157

1187

# Rule NAME FROM TO TYPE IN ON AT SAVE LETTER/S

1158

1188

Rule Chile 1927 1932 - Sep 1 0:00 1:00 S

1159

1189

Rule Chile 1928 1932 - Apr 1 0:00 0 -

1183

1213

Rule Chile 1998 only - Mar Sun>=9 3:00u 0 -

1184

1214

Rule Chile 1998 only - Sep 27 4:00u 1:00 S

1185

1215

Rule Chile 1999 only - Apr 4 3:00u 0 -

1186

Rule Chile 1999 max - Oct Sun>=9 4:00u 1:00 S

1216

Rule Chile 1999 2010 - Oct Sun>=9 4:00u 1:00 S

1217

Rule Chile 2011 only - Aug Sun>=16 4:00u 1:00 S

1218

Rule Chile 2012 max - Oct Sun>=9 4:00u 1:00 S

1187

1219

Rule Chile 2000 2007 - Mar Sun>=9 3:00u 0 -

1188

1220

# N.B.: the end of March 29 in Chile is March 30 in Universal time,

1189

1221

# which is used below in specifying the transition.

1190

1222

Rule Chile 2008 only - Mar 30 3:00u 0 -

1191

1223

Rule Chile 2009 only - Mar Sun>=9 3:00u 0 -

1192

Rule Chile 2010 only - Apr 4 3:00u 0 -

1193

Rule Chile 2011 max - Mar Sun>=9 3:00u 0 -

1224

Rule Chile 2010 only - Apr Sun>=1 3:00u 0 -

1225

Rule Chile 2011 only - May Sun>=2 3:00u 0 -

1226

Rule Chile 2012 max - Mar Sun>=9 3:00u 0 -

1194

1227

# IATA SSIM anomalies: (1992-02) says 1992-03-14;

1195

1228

# (1996-09) says 1998-03-08. Ignore these.

1196

1229

# Zone NAME GMTOFF RULES FORMAT [UNTIL]

1310

1343

# For now, we'll just record the time in Stanley, since we have no

1311

1344

# better info.

1312

1345

1346

# From Steffen Thorsen (2011-04-01):

1347

# The Falkland Islands will not turn back clocks this winter, but stay on

1348

# daylight saving time.

1349

1350

# One source:

1351

# <a href="http://www.falklandnews.com/public/story.cfm?get=5914&source=3">

1352

# http://www.falklandnews.com/public/story.cfm?get=5914&source=3

1353

# </a>

1354

1355

# We have gotten this confirmed by a clerk of the legislative assembly:

1356

# Normally the clocks revert to Local Mean Time (UTC/GMT -4 hours) on the

1357

# third Sunday of April at 0200hrs and advance to Summer Time (UTC/GMT -3

1358

# hours) on the first Sunday of September at 0200hrs.

1359

1360

# IMPORTANT NOTE: During 2011, on a trial basis, the Falkland Islands

1361

# will not revert to local mean time, but clocks will remain on Summer

1362

# time (UTC/GMT - 3 hours) throughout the whole of 2011. Any long term

1363

# change to local time following the trial period will be notified.

1313

1364

# Rule NAME FROM TO TYPE IN ON AT SAVE LETTER/S

1314

1365

Rule Falk 1937 1938 - Sep lastSun 0:00 1:00 S

1315

1366

Rule Falk 1938 1942 - Mar Sun>=19 0:00 0 -

1321

1372

Rule Falk 1984 only - Sep 16 0:00 1:00 S

1322

1373

Rule Falk 1985 2000 - Sep Sun>=9 0:00 1:00 S

1323

1374

Rule Falk 1986 2000 - Apr Sun>=16 0:00 0 -

1324

Rule Falk 2001 max - Apr Sun>=15 2:00 0 -

1375

Rule Falk 2001 2010 - Apr Sun>=15 2:00 0 -

1376

Rule Falk 2012 max - Apr Sun>=15 2:00 0 -

1325

1377

Rule Falk 2001 max - Sep Sun>=1 2:00 1:00 S

1326

1378

# Zone NAME GMTOFF RULES FORMAT [UNTIL]

1327

1379

Zone Atlantic/Stanley -3:51:24 - LMT 1890

Older »