Author Topic: Update Script for PostgreSQL Repository  (Read 2217 times)

jimbo

  • EA Novice
  • *
  • Posts: 13
  • Karma: +0/-0
    • View Profile
Update Script for PostgreSQL Repository
« on: April 23, 2014, 06:41:57 am »
Do I need to run the update script for a new PG Repository? I only assume I do is because the date of the SQL to create it is 21 Jan 2010.

I don't see a "run patch" menu item.

http://www.sparxsystems.com/resources/corporate/

"Also listed with each DBMS are update scripts, designed to improve performance on model repositories which were created using scripts downloaded prior to February 10, 2010. The update scripts add indexes to the database schema.
Note: To apply the update scripts, open the existing repository model. From the Tools menu select Run Patch."
~J

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8038
  • Karma: +118/-20
    • View Profile
Re: Update Script for PostgreSQL Repository
« Reply #1 on: April 23, 2014, 09:10:22 am »
It's not essential to run it even if your repository was created before that date.

Run patch won't help you anyway. You'll need to use whatever management client you use for your PostgreSQL databases to run the script.
« Last Edit: April 23, 2014, 09:11:30 am by simonm »