Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: jimbo on April 23, 2014, 06:41:57 am

Title: Update Script for PostgreSQL Repository
Post by: jimbo 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."

Title: Re: Update Script for PostgreSQL Repository
Post by: Eve 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.