PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16240
PG Version9.6.9
OSLinux
Opened2020-02-03 10:38:10+00
Reported byAbhishek Borra
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16240
Logged by:          Abhishek Borra
Email address:      (redacted)
PostgreSQL version: 9.6.9
Operating system:   Linux
Description:        

We have certain columns in our database of data type 'timestamp with time
zone'. We are populating them with now() function as default value
.Sometimes the date time is getting populated as dates from 2017/18
randomly. What can be the possible cause of this issue?

Messages

DateAuthorSubject
2020-02-03 10:38:10+00PG Bug reporting formBUG #16240: The now() function is populating different date time than expected
2020-02-03 14:24:50+00Tom LaneRe: BUG #16240: The now() function is populating different date time than expected