LP#1743639: Test location as proxy for location group
authorMike Rylander <mrylander@gmail.com>
Tue, 16 Jan 2018 21:26:31 +0000 (16:26 -0500)
committerKathy Lussier <klussier@masslnc.org>
Wed, 17 Jan 2018 18:20:17 +0000 (13:20 -0500)
commit262d34a60ccf292a0d76e24ffc03c0a9dd09b9cd
tree2f74867fdb1e0cc68932a1cc25086d687f8bae9d
parentcaa77ec89e9006e98d9e61d4175bcef05f000012
LP#1743639: Test location as proxy for location group

Location groups are a table remove from copies, and can cause very large
updates to the copy vis cache.  So, we will expand location groups to
locations, in situ, to avoid this problem and the need to supply a trigger
to update th copy vis cache for groups.  This will allow us to reclaim
the location group bit in the visibility cache namespace if necessary, at
a later date.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Kathy Lussier <klussier@masslnc.org>
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm
Open-ILS/src/sql/Pg/300.schema.staged_search.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.function.copy_location_group_visible.sql