Re: After upgrade from 9.4.1-3 to 10.15 and fresh install of 10.15 have some differences in the schema definition

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: java reddy <jrjavajava(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: After upgrade from 9.4.1-3 to 10.15 and fresh install of 10.15 have some differences in the schema definition
Date: 2021-03-01 14:36:26
Message-ID: 715798.1614609386@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

java reddy <jrjavajava(at)gmail(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-03-01 14:40:07 Re: BUG #16904: Dropping and recreating a large table with 5 indexes slowed down query performance
Previous Message Daniel Gustafsson 2021-03-01 14:04:40 Re: Bug in error reporting for multi-line JSON