mahara-contributors team mailing list archive

[Richard Mansfield <784322@xxxxxxxxxxxxxxxxxx>]

** Also affects: mahara/1.4
   Importance: Undecided
       Status: New

** Changed in: mahara/1.4
     Assignee: (unassigned) => Richard Mansfield (richard-mansfield)

** Changed in: mahara/1.4
       Status: New => Confirmed

** Changed in: mahara/1.4
   Importance: Undecided => Medium

** Changed in: mahara/1.4
    Milestone: None => 1.4.0

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

Title:
  Restore username index

Status in Mahara ePortfolio:
  Confirmed
Status in Mahara 1.4 series:
  Confirmed

Bug description:
  It seems like change_field_precision can silently drop db indexes on
  the column, at least on postgres.  We need to check whether the
  username unique index exists & recreate it if necessary.

  In theory duplicates could have snuck in between 20110506 and
  20110518, but the application tries hard to stop this from happening,
  and no stable version has the username upgrade yet, so recreating the
  index should just work.