Maple T.A. 5.0 Hotfixes Details and Downloads - Downloads and Service Packs - Technical Support Center - Maplesoft
   
  Explore Customer Support
  Customer Support Home
Frequently Asked Questions
Maple Online Help
Support Request Form
Offline Activation Request
Download Product Updates
Training
Support Policies

  User Resources
  Product Manuals and Installation Instructions
MaplePrimes
Welcome Center
Maple Application Center
Recorded Webinars
Live Webinars

  Stay Informed
 

Subscribe to the Maple Reporter
Become a Member


    Home : Support : Downloads & Service Packs : Hotfix 500-006 – Additional Instructions

Hotfix 500-006 – Additional Instructions

To apply this fix, you must run the SQL script, 500-006.sql, which will create a set of indexes to improve database performance. The script file is located in the files/sql sub-directory of the hotfix directory. The script should be applied manually against "mapleta" database. To run the script, follow these instructions.

  1. Start pgAdmin.
  2. Double-click the "PostgreSQL Server" node to open it. You will need to supply your Postgres password.
  3. Click on the "mapleta" database node to select it.
  4. Select [Tools][Query tool] menu.
  5. Paste the content of the "files/sql/500-006.sql" script into the query pane (upper left)
  6. Press F5 to execute the command. You should see a response similar to the following, in the "Output pane", underneath the query pane.

    NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_class_pkey" for table "assignment_class"
    NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_advanced_policy_pkey" for table "assignment_advanced_policy"
    NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_mastery_penalty_pkey" for table "assignment_mastery_penalty"
    NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_mastery_policy_pkey" for table "assignment_mastery_policy"
    NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_policy_pkey" for table "assignment_policy"
    NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_question_group_pkey" for table "assignment_question_group"
    NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pk_question" for table "question"
    NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "assignment_question_group_map_pkey" for table "assignment_question_group_map"
    NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pk_question_group" for table "question_group"
    NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pk_question_group_map" for table "question_group_map"
    NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index "unique_question_group_map" for table "question_group_map"

    Query returned successfully with no result in 2107 ms.

    The execution time will be different for different systems.

  7. Exit the query tool, and exit pgAdmin III. You are finished

    Return to Maple T.A. 5.0 Hotfixes