Reviewed:  https://reviews.mahara.org/313
Committed: 
http://gitorious.org/mahara/mahara/commit/166d78921d839588f15cc1c907cb02ef4045f3e6
Submitter: Richard Mansfield ([email protected])
Branch:    master

commit 166d78921d839588f15cc1c907cb02ef4045f3e6
Author: Richard Mansfield <[email protected]>
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 <[email protected]>

-- 
You received this bug notification because you are a member of Mahara
Reviewers, 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

_______________________________________________
Mailing list: https://launchpad.net/~mahara-core
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~mahara-core
More help   : https://help.launchpad.net/ListHelp

Reply via email to