projects / evergreen / equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: efedb3b) | patch
lp#1007248: tweak order in which pgt rows are renumbered
authorGalen Charlton <gmc@esilibrary.com>
Fri, 1 Jun 2012 03:31:11 +0000 (23:31 -0400)
committerBill Erickson <berick@esilibrary.com>
Fri, 1 Jun 2012 19:42:04 +0000 (15:42 -0400)
commit765db53ef7bff1129641e24e7d1b5d0cf954f16f
treeffd403718f2f411309b351fce290b616ddace528tree
parentefedb3be5075d11f9c60c2f9814d5cdcd6c1f540commit | diff
lp#1007248: tweak order in which pgt rows are renumbered

Need to renumber from highest to lowest.  Because the primary
key constraint is not deferred, doing the renumbering in a single
statement will fail if there is overlap between the set of
existing pgt.id values and the set of {pgt.id + 100}.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
Signed-off-by: Bill Erickson <berick@esilibrary.com>
Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql diff | blob | history
Evergreen working repo (Equinox)