pgsql: Fix the various forms of AT TIME ZONE to accept either timezones

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix the various forms of AT TIME ZONE to accept either timezones
Date: 2005-09-09 02:31:50
Message-ID: 20050909023150.61F10D6E65@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Fix the various forms of AT TIME ZONE to accept either timezones found
in the zic database or zone names found in the date token table. This
preserves the old ability to do AT TIME ZONE 'PST' along with the new
ability to do AT TIME ZONE 'PST8PDT'. Per gripe from Bricklen Anderson.
Also, fix some inconsistencies in usage of TZ_STRLEN_MAX --- the old
code had the potential for one-byte buffer overruns, though given
alignment considerations it's unlikely there was any real risk.

Modified Files:
--------------
pgsql/doc/src/sgml:
datetime.sgml (r2.46 -> r2.47)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datetime.sgml.diff?r1=2.46&r2=2.47)
func.sgml (r1.283 -> r1.284)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.283&r2=1.284)
pgsql/src/backend/utils/adt:
date.c (r1.119 -> r1.120)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/date.c.diff?r1=1.119&r2=1.120)
timestamp.c (r1.151 -> r1.152)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.151&r2=1.152)
pgsql/src/include:
pgtime.h (r1.9 -> r1.10)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/pgtime.h.diff?r1=1.9&r2=1.10)
pgsql/src/timezone:
pgtz.c (r1.36 -> r1.37)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/pgtz.c.diff?r1=1.36&r2=1.37)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2005-09-09 06:46:15 pgsql: timestamptz_izone should return the input, not NULL, when the
Previous Message Tom Lane 2005-09-08 20:07:42 pgsql: Create the pg_pltemplate system catalog to hold template