pgsql: Reject nonzero day fields in AT TIME ZONE INTERVAL functions. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Reject nonzero day fields in AT TIME ZONE INTERVAL functions.
Date
Msg-id E1U0xgk-0005sd-O6@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Reject nonzero day fields in AT TIME ZONE INTERVAL functions.

It's not sensible for an interval that's used as a time zone value to be
larger than a day.  When we changed the interval type to contain a separate
day field, check_timezone() was adjusted to reject nonzero day values, but
timetz_izone(), timestamp_izone(), and timestamptz_izone() evidently were
overlooked.

While at it, make the error messages for these three cases consistent.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/9afc58396af75d59ea2eec467724faf68fe63890

Modified Files
--------------
src/backend/utils/adt/date.c      |    4 ++--
src/backend/utils/adt/timestamp.c |    8 ++++----
2 files changed, 6 insertions(+), 6 deletions(-)


pgsql-committers by date:

Previous
From: Magnus Hagander
Date:
Subject: pgsql: Properly zero-pad the day-of-year part of the win32 build number
Next
From: Simon Riggs
Date:
Subject: pgsql: Switch timelines if we crash soon after promotion.