mahara-contributors team mailing list archive

[Mahara Bot <dev@xxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/313
Committed: http://gitorious.org/mahara/mahara/commit/166d78921d839588f15cc1c907cb02ef4045f3e6
Submitter: Richard Mansfield (richardm@xxxxxxxxxx)
Branch:    master

commit 166d78921d839588f15cc1c907cb02ef4045f3e6
Author: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>
Date:   Mon Jun 13 15:35:28 2011 +1200

    Make index_exists more useful when called on indexes with no columns (bug #796102)
    
    ddl's index_exists() function tries to check whether an index exists on a table
    by comparing the column names in the index passed to it with all the indexes on
    the table.
    
    Indexes on functions of columns all appear as having no columns, so the behaviour
    is not very useful.  If a table has any index on a function, index_exists will
    always return true when passed an index with no columns, whether or not its name
    matches any existing index on the table.
    
    This change modifies find_index_name() so that it treats indexes without columns
    as a special case, and matches on their names rather than on the list of columns.
    
    Change-Id: Ic0d664dff77fe5a220a9f9563975df1c87b18e06
    Signed-off-by: Richard Mansfield <richard.mansfield@xxxxxxxxxxxxxxx>

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/796102

Title:
  User search index: db upgrade warning on postgres

Status in Mahara ePortfolio:
  In Progress

Bug description:
  The DB upgrade fails on "if (!index_exists($table, $index)) {" (though
  it's a warning, not an error)

  The upgrade went through and finished but none of these new indexes
  were created.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/796102/+subscriptions