Re: log_rotation_age integer overflow display quirk

--On Freitag, Juli 04, 2008 11:31:07 +0200 Stefan Kaltenbrunner
<stefan(at)kaltenbrunner(dot)cc> wrote:

> I just noticed that setting log_rotation_age to a value larger than 24
> days results in rather weird output (I have not actually tested yet if
> that affects the functionality too or just the output):
>
>
> test=# show log_rotation_age;
> log_rotation_age
> ------------------
> -2134967296ms
> (1 row)

This seems to be a bug in _ShowOption(), where the corresponding value is
converted into milliseconds to get the biggest possible time unit to
display. This overflows the result variable (which is declared as int),
causing this strange output.

--
Thanks

Bernd