projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: c0c481c) | patch
lp#1007248: tweak order in which pgt rows are renumbered user/gmcharlt/lp1007248_better_pgt_id_renumbering
authorGalen Charlton <gmc@esilibrary.com>
Fri, 1 Jun 2012 03:31:11 +0000 (23:31 -0400)
committerGalen Charlton <gmc@esilibrary.com>
Fri, 1 Jun 2012 03:31:11 +0000 (23:31 -0400)
commit2323bd961d9e0d26b017902032a16477e527ed14
tree2b4bcf98da1e3ad0efa2cc032533f671b47da0a4tree
parentc0c481c333e30d9a100ca15557009cff045af7a8commit | 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>
Open-ILS/src/sql/Pg/version-upgrade/2.0-2.1-upgrade-db.sql diff | blob | history
Evergreen ILS