From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Tom Lane <tgl(at)postgresql(dot)org> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [COMMITTERS] pgsql: Fix up some problems in handling of |
Date: | 2006-10-21 19:09:35 |
Message-ID: | 200610211909.k9LJ9Zu27774@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
And this closes all the recent open issues with timezones, right?
---------------------------------------------------------------------------
Tom Lane wrote:
> Log Message:
> -----------
> Fix up some problems in handling of zic-style time zone names in datetime
> input routines. Remove the former "DecodePosixTimezone" function in favor of
> letting the zic code handle POSIX-style zone specs (see tzparse()). In
> particular this means that "PST+3" now means the same as "-03", whereas it
> used to mean "-11" --- the zone abbreviation is effectively just a noise word
> in this syntax. Make sure that all named and POSIX-style zone names will be
> parsed as a single token. Fix long-standing bogosities in printing and input
> of fractional-hour timezone offsets (since the tzparse() code will accept
> these, we'd better make 'em work). Also correct an error in the original
> coding of the zic-zone-name patch: in "timestamp without time zone" input,
> zone names are supposed to be allowed but ignored, but the coding was such
> that the zone changed the interpretation anyway.
>
> Modified Files:
> --------------
> pgsql/doc/src/sgml:
> datatype.sgml (r1.177 -> r1.178)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datatype.sgml.diff?r1=1.177&r2=1.178)
> datetime.sgml (r2.54 -> r2.55)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datetime.sgml.diff?r1=2.54&r2=2.55)
> pgsql/src/backend/utils/adt:
> datetime.c (r1.172 -> r1.173)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.172&r2=1.173)
> pgsql/src/test/regress/expected:
> horology.out (r1.62 -> r1.63)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/horology.out.diff?r1=1.62&r2=1.63)
> timestamp.out (r1.30 -> r1.31)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/timestamp.out.diff?r1=1.30&r2=1.31)
> timestamptz.out (r1.20 -> r1.21)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/timestamptz.out.diff?r1=1.20&r2=1.21)
> pgsql/src/test/regress/sql:
> timestamp.sql (r1.16 -> r1.17)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/timestamp.sql.diff?r1=1.16&r2=1.17)
> timestamptz.sql (r1.9 -> r1.10)
> (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/timestamptz.sql.diff?r1=1.9&r2=1.10)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2006-10-21 21:03:04 | pgsql: Translations update |
Previous Message | Tom Lane | 2006-10-21 18:41:53 | pgsql: Further release-note editorialization. |
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2006-10-21 19:12:07 | Re: xlogdump fixups and WAL log question. |
Previous Message | Bruce Momjian | 2006-10-21 18:00:19 | Re: [SPAM?] Re: Asynchronous I/O Support |