LP1842940: stamping and slight tweak to upgrade script
authorJane Sandberg <sandbej@linnbenton.edu>
Tue, 1 Oct 2019 21:47:07 +0000 (14:47 -0700)
committerJane Sandberg <sandbej@linnbenton.edu>
Tue, 1 Oct 2019 22:52:05 +0000 (15:52 -0700)
commite2ed5405cd97efc908f2acf470678894dcf5f544
tree6461745d3e5917904e7ebb72f96dec85bd6005bd
parent759258ce4e53d8d71d3c1956b95523d8162ce9e0
LP1842940: stamping and slight tweak to upgrade script

Mike Rylander suggested the INSERT ... SELECT ... WHERE NOT
EXISTS approach, since this fix is being backported to older
releases, and we don't want to cause duplicate entries or
upgrade failures if the perm already exists

Signed-off-by: Jane Sandberg <sandbej@linnbenton.edu>
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/upgrade/1191.data.lp1842940_staff_edit_self_perm.sql [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1842940_staff_edit_self_perm.sql [deleted file]