Re: proposal: rounding up time value less than its unit. - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: proposal: rounding up time value less than its unit.
Date
Msg-id 5425B5A9.2080500@agliodbs.com
Whole thread Raw
In response to Re: proposal: rounding up time value less than its unit.  (David Johnston <david.g.johnston@gmail.com>)
List pgsql-hackers
On 09/26/2014 11:17 AM, Tom Lane wrote:
> So I'm coming around to the idea that "throw an error if a nonzero
> input would round (or truncate) to zero" is a reasonable solution.
> I think it'd be even more reasonable if we also fixed the rounding
> rule to be "round to nearest", but the two changes can be considered
> independently.

I'm good with the error.  We'll want to add stuff to both the docs and
pg_settings to *show* the minimum value, and an informative error
message would help, i.e.:

"Invalid value for log_rotation_interval.  Minimum value is 1min"

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: David G Johnston
Date:
Subject: Re: proposal: rounding up time value less than its unit.
Next
From: Gregory Smith
Date:
Subject: Re: proposal: rounding up time value less than its unit.