]> git.evergreen-ils.org Git - Evergreen.git/commit
LP#836768 Proximity update trigger
authorSteven Callender <stevecallender@esilibrary.com>
Mon, 29 Aug 2011 15:11:18 +0000 (15:11 +0000)
committerMike Rylander <mrylander@gmail.com>
Wed, 7 Sep 2011 18:08:36 +0000 (14:08 -0400)
commit5154c4e237a76ca4fcda95fcea5381e9a07ce27d
tree4e7e6ed86f0bea887f4f265800257ecbeff91a5b
parent59d09ca287a7c4ec83657d26c902ac13d0b700aa
LP#836768 Proximity update trigger

Update org proximity automatically when parent org unit is changed to avoid the need to use the autogen -u parameter,
by means of a trigger on the actor.org_unit table and a new function.

Signed-off-by: Steven Callender <stevecallender@esilibrary.com>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/020.schema.functions.sql
Open-ILS/src/sql/Pg/upgrade/xxxx.schema.actor_org_unit_trigger_prox_update.sql [new file with mode: 0644]