pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
After upgrade from 9.4.1-3 to 10.15 and fresh install of 10.15 have some differences in the schema definition
2+ messages / 2 participants
[nested] [flat]

* After upgrade from 9.4.1-3 to 10.15 and fresh install of 10.15 have some differences in the schema definition
@ 2021-03-01 10:19  java reddy <jrjavajava@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: java reddy @ 2021-03-01 10:19 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org

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

Attachments:

fullkit_sql.JPG (image/jpeg, 132.0K) download view image
upgradekit_sql.JPG (image/jpeg, 142.8K) download view image
^ permalink raw reply [nested|flat] 2+ messages in thread

* Re: After upgrade from 9.4.1-3 to 10.15 and fresh install of 10.15 have some differences in the schema definition
@ 2021-03-01 14:36  Tom Lane <tgl@sss.pgh.pa.us>
  parent: java reddy <jrjavajava@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2021-03-01 14:36 UTC (permalink / raw)
  To: java reddy <jrjavajava@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2021-03-01 14:36 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-01 10:19 After upgrade from 9.4.1-3 to 10.15 and fresh install of 10.15 have some differences in the schema definition java reddy <jrjavajava@gmail.com>
2021-03-01 14:36 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox