BUG #5050: text to timestamp failure

From: "Aoyai Kouhei" <aoyagi(dot)kouhei(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5050: text to timestamp failure
Date: 2009-09-12 15:49:22
Message-ID: 200909121549.n8CFnMkH055814@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5050
Logged by: Aoyai Kouhei
Email address: aoyagi(dot)kouhei(at)gmail(dot)com
PostgreSQL version: 8.4.1
Operating system: MacOS 10.6.1
Description: text to timestamp failure
Details:

select '0001-01-01'::timestamp with time zone;
-> "0001-01-01 00:00:00+09:18:59"

...

select '1887-01-01'::timestamp with time zone;
-> "1887-01-01 00:00:00+09:18:59"

select '1888-01-01'::timestamp with time zone;
-> "1888-01-01 00:00:00+09"

select '1889-01-01'::timestamp with time zone;
-> "1889-01-01 00:00:00+09"

...

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-09-12 19:58:20 Re: BUG #5050: text to timestamp failure
Previous Message Luke Koops 2009-09-12 03:37:37 Re: BUG #5038: WAL file is pending deletion in pg_xlog folder, this interferes with WAL archiving.