After upgrade from 9.4.1-3 to 10.15 and fresh install of 10.15 have some differences in the schema definition
Hi Team,
I have one fresh install and other one is upgrade path (from 94. to
10.15).I am compare schema definitions full install versus upgrade path.
I see some differences.
1. CURRENT_TIMESTAMP is replaced with now()
2.('now'::text)::timestamp without time zone is replaced with
LOCAL_TIMESTAMP
Does anybody have any idea?
Regards,
Sankar
java reddy <jrjavajava@gmail.com> writes:
I have one fresh install and other one is upgrade path (from 94. to
10.15).I am compare schema definitions full install versus upgrade path.
I see some differences.
1. CURRENT_TIMESTAMP is replaced with now()
2.('now'::text)::timestamp without time zone is replaced with
LOCAL_TIMESTAMP
v10 and later preserve CURRENT_TIMESTAMP and some similar SQL-standard
constructs as entered, when dumping the contents of views, column default
expressions, and the like. Older versions replaced them with PG-specific
equivalents. Neither behavior is a bug.
regards, tom lane