BUG #8230: Time interval size overflow

From: rok(dot)kralj(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8230: Time interval size overflow
Date: 2013-06-16 11:03:53
Message-ID: E1UoAkT-0006qe-E5@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8230
Logged by: Rok Kralj
Email address: rok(dot)kralj(at)gmail(dot)com
PostgreSQL version: 9.2.4
Operating system: Arch Linux
Description:

As far as I know, the INTERVAL type is represented using three int32, one
for months, days and milliseconds.

However, overflow detections seems to work correctly only on these three
types; if they get overflown indirectly, they do not get detected:

SELECT INTERVAL '3000000000 days'
ERROR: interval field value out of range: "3000000000 days"

SELECT INTERVAL '2000000000 years'
-147483648 years

I'm surprised this hasn't been reported yet. The expected behaviour is to
raise an error.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Kupershmidt 2013-06-17 12:47:13 Re: [BUGS] BUG #7873: pg_restore --clean tries to drop tables that don't exist
Previous Message Jeff Frost 2013-06-14 17:06:47 Re: BUG #8225: logging options don't change after reload