PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16027
PG VersionUnsupported/Unknown
OSCentOS 6.10
Opened2019-09-26 15:20:56+00
Reported byJeff Sturm
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16027
Logged by:          Jeff Sturm
Email address:      (redacted)
PostgreSQL version: Unsupported/Unknown
Operating system:   CentOS 6.10
Description:        

Actual version is 8.4.20.

With a date in year 1904 or earlier, the to_timestamp function outputs
unexpected characters:

template1=# select to_timestamp('19041231','YYYYMMDD');
         to_timestamp
------------------------------
 1904-12-31 00:00:00-05:32:11

Expected is "1904-12-31 00:00:00-06"

Messages

DateAuthorSubject
2019-09-26 15:20:56+00PG Bug reporting formBUG #16027: Invalid output of to_timestamp
2019-09-26 15:39:17+00Tom LaneRe: BUG #16027: Invalid output of to_timestamp
2019-09-26 16:03:42+00Jeffrey SturmRE: BUG #16027: Invalid output of to_timestamp
2019-09-26 16:31:43+00Tom LaneRe: BUG #16027: Invalid output of to_timestamp