Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Interval aggregate regression failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, Michael Glaesemann <grzm(at)seespotcode(dot)net>, Michael Paesold <mpaesold(at)gmx(dot)at>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] Interval aggregate regression failure
Date: 2006-08-31 19:46:08
Message-ID: 23114.1157053568@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Well, the patch only multiplies by 30, so the interval would have to
> span +5 million years to overflow.  I don't see any reason to add
> rounding until we get an actual query that needs it

Have you tried your patch against the various cases that have been
discussed in the past?  In particular there were several distinct
examples of this behavior posted at the beginning of the thread, and
I'd not assume that a fix for one handles them all.

BTW, while trolling for examples I came across this:
http://archives.postgresql.org/pgsql-bugs/2005-10/msg00307.php
pointing out some issues that still haven't been addressed.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Chris BrowneDate: 2006-08-31 19:59:05
Subject: Re: Thought provoking piece on NetBSD
Previous:From: Victor B. WagnerDate: 2006-08-31 19:44:00
Subject: Re: [PATCHES] Backend SSL configuration enhancement

pgsql-patches by date

Next:From: Bruce MomjianDate: 2006-08-31 20:05:43
Subject: Re: [HACKERS] Interval aggregate regression failure
Previous:From: Victor B. WagnerDate: 2006-08-31 19:44:00
Subject: Re: [PATCHES] Backend SSL configuration enhancement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group