pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedAfter 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>
2021-03-01 14:36 ` Re: After upgrade from 9.4.1-3 to 10.15 and fresh install of 10.15 have some differences in the schema definition Tom Lane <tgl@sss.pgh.pa.us>
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 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>
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