Re: Time Fields

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "robert" <robert(at)vocalscape(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Time Fields
Date: 2001-01-23 02:55:21
Message-ID: 26916.980218521@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"robert" <robert(at)vocalscape(dot)com> writes:
> We have just installed postgres on a completly rebuild linux 6.2 redhat
> server. The problem is that when we add a data to our time fields it loses
> one minite and when we add data to our timestamp field it adds 60 seconds.

We've heard reports of roundoff errors like that when the wrong compiler
flags are used on certain hardware platforms. What is your hardware,
and how did you build or obtain the Postgres executables? What Postgres
version is this, anyway?

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mikhail Utin 2001-01-23 04:35:22 forgotten data base superuser password
Previous Message robert 2001-01-23 02:17:28 Time Fields