Postgres Pro
Downloads
Home   >   mailing lists

BUG #16240: The now() function is populating different date time than expected - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16240: The now() function is populating different date time than expected
Date
Msg-id 16240-81d13113beecf3cb@postgresql.org
Whole thread Raw
Responses Re: BUG #16240: The now() function is populating different date time than expected  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      16240
Logged by:          Abhishek Borra
Email address:      borratejaabhi@gmail.com
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?

pgsql-bugs by date:

Previous
From: Arseny Sher
Date:
Subject: Re: ERROR: subtransaction logged without previous top-level txn record
Next
From: Amit Kapila
Date:
Subject: Re: ERROR: subtransaction logged without previous top-level txn record