LP 1506534: Improve czifm z3950_attr_type Check user/jboyer/lp1506534_z3950_attr_check
authorJason Boyer <jboyer@library.in.gov>
Tue, 29 Dec 2015 18:53:04 +0000 (13:53 -0500)
committerJason Boyer <jboyer@library.in.gov>
Wed, 30 Dec 2015 13:29:37 +0000 (08:29 -0500)
commita54ce055868a0cfded6e58b651631aab365f872b
treeeba264646bf5491f54706cef9abf8935466e7ed6
parent616dc3a884a4f894d0aa38ba4b701b4f2108a447
LP 1506534: Improve czifm z3950_attr_type Check

Rather than use a CHECK constraint, this patch
uses a CONSTRAINT TRIGGER, er, constraint to verify
the z3950_attr_type field. This allows the trigger
to be deferred as any other deferrable constraint
and also allows parallel pg_restore jobs to complete
properly.

Signed-off-by: Jason Boyer <jboyer@library.in.gov>
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/t/lp1506534_z3950_attr_check.pg [new file with mode: 0644]
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.config_z3950_attr_check.sql [new file with mode: 0644]