| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Strange interval arithmetic |
| Date: | 2005-11-30 16:50:56 |
| Message-ID: | 20051130165056.GA89793@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On Sun, Nov 27, 2005 at 11:27:54AM -0700, Michael Fuhr wrote:
> On Sun, Nov 27, 2005 at 08:45:18AM -0700, Michael Fuhr wrote:
> > Looks like the value is stuck at 2^31 - 1 seconds:
>
> I see this behavior back to at least 7.3. I'd guess it's because
> strtol() indicates overflow by returning LONG_MAX and setting errno
> to ERANGE, but the code doesn't check for that.
Is this worth looking at for the upcoming dot releases? It's
apparently a longstanding behavior that almost nobody encounters,
yet knowingly not addressing it seems a bit MySQLish ;-) Here's
the start of the thread for anybody who missed it:
http://archives.postgresql.org/pgsql-hackers/2005-11/msg01385.php
--
Michael Fuhr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-11-30 17:37:40 | Re: Strange interval arithmetic |
| Previous Message | Tom Lane | 2005-11-30 16:40:30 | Re: Upcoming PG re-releases |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-11-30 17:37:40 | Re: Strange interval arithmetic |
| Previous Message | Michael Meskes | 2005-11-30 13:01:24 | Re: Add missing const qualifier in ECPG |