LP#1176206: improve deadlock handling in 2.3-2.4-supplemental.sh
authorGalen Charlton <gmc@esilibrary.com>
Fri, 3 May 2013 21:20:21 +0000 (17:20 -0400)
committerDan Scott <dscott@laurentian.ca>
Tue, 4 Jun 2013 18:16:49 +0000 (14:16 -0400)
commit2a6a2f82a8f0324ce8b16649e512d64e90d73d3a
treeca06d207672f190b3ec5471b109812990984e82a
parent7a178391d7290f51eac70ada4f8804794e851fd1
LP#1176206: improve deadlock handling in 2.3-2.4-supplemental.sh

- make sure that it doesn't attempt to create more than one
  index at a time for a given table
- if deadlocks occur (because of a PostgreSQL bug whose fix
  isn't slated for release until after April 2013), find
  and recreate the affected indexes.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Dan Scott <dscott@laurentian.ca>
Open-ILS/src/sql/Pg/version-upgrade/2.3-2.4-supplemental.sh