projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 509c09e) | 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:34 +0000 (15:42 -0400)
commit2004f9b2103deee59df4e6adacfa1e4a05e09a84
tree2785c487161ac149445d8c35dd9c38817e9911fctree
parent509c09ed9e472f15da0753f64e82f920efb0edaacommit | 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 (PINES)