pgsql: Fix overflow in extract(epoch from interval) for intervals

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix overflow in extract(epoch from interval) for intervals
Date: 2007-09-16 15:56:39
Message-ID: 20070916155639.BC20C753E4C@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Fix overflow in extract(epoch from interval) for intervals exceeding 68 years.
Seems to have been introduced in 8.1 by careless SECS_PER_DAY
search-and-replace.

Tags:
----
REL8_1_STABLE

Modified Files:
--------------
pgsql/src/backend/utils/adt:
timestamp.c (r1.157.2.1 -> r1.157.2.2)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c?r1=1.157.2.1&r2=1.157.2.2)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2007-09-16 16:33:04 pgsql: Remove Assert(BgWriterShmem != NULL), which is rather pointless
Previous Message Tom Lane 2007-09-16 15:56:32 pgsql: Fix overflow in extract(epoch from interval) for intervals