]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c91ed7b) | 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:41:06 +0000 (15:41 -0400)
commit573f15ee1d309f4f79b41e4802013d0ee271fdf8
tree0fc92c9217f0764106f501277d599df3f232c740tree
parentc91ed7b35048fc59ccb36468e81aae6f3ad42958commit | 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 ILS