pgsql: Be more wary in choice of timezone names to test make_timestampt

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Be more wary in choice of timezone names to test make_timestampt
Date: 2014-05-13 00:21:25
Message-ID: E1Wk0TF-0001u7-4u@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Be more wary in choice of timezone names to test make_timestamptz with.

America/Metlakatla hasn't been in the IANA database all that long, so
some installations might not have it. It does seem worthwhile to test
with a fractional-minute GMT offset, but we can get that from almost
any pre-1900 date; I chose Europe/Paris, whose LMT offset from Greenwich
should be pretty darn well established.

Also, assuming that Mars/Mons_Olympus will never be in the IANA database
seems less than future-proof, so let's use a more fanciful location for
the bad-zone-name check.

Per complaint from Christoph Berg.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/66b737cd9a72e10df4de1867ae7b675bc48d478c

Modified Files
--------------
src/test/regress/expected/timestamptz.out | 16 +++++-----------
src/test/regress/sql/timestamptz.sql | 7 +++----
2 files changed, 8 insertions(+), 15 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2014-05-13 01:31:41 pgsql: doc: 9.4 release note adjustments
Previous Message Tom Lane 2014-05-12 23:32:51 Re: pgsql: Revive line type