mahara-contributors team mailing list archive

[Richard Mansfield <784322@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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.

** Affects: mahara
     Importance: Medium
     Assignee: Richard Mansfield (richard-mansfield)
         Status: Confirmed

-- 
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

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.