Re: integer datetimes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: integer datetimes
Date
Msg-id 24291.1171470451@sss.pgh.pa.us
Whole thread Raw
In response to integer datetimes  (Magnus Hagander <magnus@hagander.net>)
Responses Re: integer datetimes  (Magnus Hagander <magnus@hagander.net>)
Re: integer datetimes  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
> Our docs for the integer datetime option says:
> Note also that the integer datetimes
> code is newer than the floating-point code, and we still find bugs in it
> from time to time.

> Is the last sentence about bugs really true anymore? At least the buildfarm
> seems to have a lot *more* machines with it enabled than without.

Buildfarm proves only that the regression tests don't expose any bugs,
not that there aren't any.

> (I'm thinking about making it the defautl for the vc++ build, which is
> why I came across that)

FWIW, there are several Linux distros that build their RPMs that way,
so it's not like people aren't using it.  But it seems like we find bugs
in the datetime/interval stuff all the time, as people trip over
different weird edge cases.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Writing triggers in C++
Next
From: Neil Conway
Date:
Subject: Re: Writing triggers in C++