Re: Re: Strange results of CURRENT_TIMESTAMP

From: Marek PUBLICEWICZ <M(dot)Publicewicz(at)elka(dot)pw(dot)edu(dot)pl>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: Strange results of CURRENT_TIMESTAMP
Date: 2001-03-22 14:59:14
Message-ID: Pine.SOL.4.30.0103221553240.15623-100000@elektron.elka.pw.edu.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Thu, 22 Mar 2001, Thomas Lockhart wrote:

> > - fields defined as TIMESTAMP DEFAULT CURRENT_TIMESTAMP sometimes generate
> > invalid format of the date, for instance:
> > 2001-02-10 13:11:60.00+01
>
> You are running the Mandrake RPMs? Or have otherwise compiled using the
> -ffast-math compiler flag?
>

I'm on the Mandrake but I'm using the compiled (from the sources) version
of PostgreSQL. As a matter of fact I dont't remember, wheter or not I put
the -ffast-math flag. Is this the reason for the inaccuracy?

If so - is it responsible also for the 'underflow' error?

Mark

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2001-03-22 15:06:31 Re: Re: Call for platforms
Previous Message Tom Lane 2001-03-22 14:56:06 Re: pgindent run?