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

From: java reddy <jrjavajava(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: 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 10:19:20
Message-ID: CA+pZvhHedok=Mc03dOa7Es0u0p3as31jeqQQ64=d_pc+OR14hQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Attachment Content-Type Size
fullkit_sql.JPG image/jpeg 132.0 KB
upgradekit_sql.JPG image/jpeg 142.8 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2021-03-01 11:25:01 Re: BUG #16886: string equivalence predicate causes system slowdown
Previous Message PG Bug reporting form 2021-03-01 09:08:38 BUG #16905: Dropping and recreating a large table with 5 indexes slowed down query performance