Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13' - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13'
Date
Msg-id 20030819230405.H91017-100000@megazone.bigpanda.com
Whole thread Raw
In response to postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13' - PK v iolation  (Arnold Mavromatis <A.Mavromatis@bom.gov.au>)
List pgsql-bugs
On Wed, 20 Aug 2003, Arnold Mavromatis wrote:

> PostgreSQL info
> Server version PostgreSQL 7.3.2 on hppa2.0w-hp-hpux11.11
> Engine Version             7.3.2
> Compiled                     by GCC 3.2.1

I couldn't duplicate on Redhat9 using 7.3.4 or 7.4 beta.

What does a plain select to_date('1901-12-13', 'YYYY-MM-DD')
and select to_date('1901-12-14', 'YYYY-MM-DD') give you?
And did you give --enable-integer-datetimes to configure, and
what compilation options were used on the files (specifically was
-O2 used or a higher level, was -ffast-math used, etc...)?

pgsql-bugs by date:

Previous
From: Arnold Mavromatis
Date:
Subject: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12-13' - PK v iolation
Next
From: Arnold Mavromatis
Date:
Subject: FW: postgresql 7.3.2 bug on date '1901-12-13' and '1901-12 -13'