On Friday, April 6, 2018, David G. Johnston <
david.g.johnston@gmail.com> wrote:
On Friday, April 6, 2018, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 15145
Logged by: Paj Dib Xyooj
Email address: dibxyooj96@gmail.com
PostgreSQL version: 9.4.5
Operating system: (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit
Description:
i set column "document_datenow timestamp with time zone NOT NULL DEFAULT
now()"
but the values that like this "0001-12-31 23:42:04+06:42:04 BC"
What does typing "date" at your o/s command line show?
So, that a constant time is used is not unusual, it's documented. Now() is a function that gets resolved at default creation. You need to use "current_timestamp" literal special value if you want insertion time defaults. But since you didn't create the table in BC with an odd time zone offset either you gave bad example or there is still something wrong in your environment.
David J.