I just tried this on Debian with glibc 2.0.6 and it works fine. That is
my 6.3 postgresql release outputs 4 hours.
Michael
--
Dr. Michael Meskes, Projekt-Manager | topystem Systemhaus GmbH
meskes@topsystem.de | Europark A2, Adenauerstr. 20
meskes@debian.org | 52146 Wuerselen
Go SF49ers! Use Debian GNU/Linux! | Tel: (+49) 2405/4670-44
> ----------
> From: Thomas G. Lockhart[SMTP:lockhart@alumni.caltech.edu]
> Sent: Freitag, 13. Februar 1998 17:57
> To: Fred.Reimer@ctg.hboc.com; Bruce Momjian
> Cc: hackers@postgreSQL.org
> Subject: [HACKERS] Re: [PORTS] v6.3 release ToDo list and
> supported ports
>
> > Is the ix86/linux "confirmed" port using libc 5 or glibc 2.x (aka
> > libc6)? As most major distributions are going to release all new
> > versions with glibc I think it's prudent to test on both "platforms"
> > independently.
>
> Yes, that is a good point. There is a known bug in the glibc2 math
> library which breaks the date/time routines:
>
> select '4 hours'::timespan;
> ---------
> @ 4 hours
> (1 row)
>
> comes out instead as
> tgl=> select '4 hours'::timespan;
> ----------------------------
> @ 3 hours 59 mins 60.00 secs
> (1 row)
>
> Oliver was working on patches. Lost his e-mail message; is Oliver
> still
> here? I've got a RH5.0 linux system at work now, and the shipped
> Postgres
> installation has this problem. I'd like to see it fixed...
>
> Bruce, can you add this to the v6.3 ToDo (assuming you agree to take
> it
> on :)
>
> - Tom
>
>
>
