From 8f2fe7b084aba5c067865fb208543b79319706fb Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 2 Mar 2011 15:29:21 -0500 Subject: [PATCH] Correct TRIGGER syntax --- Open-ILS/src/sql/Pg/040.schema.asset.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 0333d47264..bd7c44ddd5 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -304,7 +304,7 @@ CREATE TABLE asset.call_number_prefix ( label TEXT NOT NULL, -- i18n label_sortkey TEXT ); -CREATE TRIGGER prefix_normalize_tgr ON asset.call_number_prefix BEFORE INSERT OR UPDATE FOR EACH ROW EXECUTE asset.normalize_affix_sortkey(); +CREATE TRIGGER prefix_normalize_tgr BEFORE INSERT OR UPDATE ON asset.call_number_prefix FOR EACH ROW EXECUTE asset.normalize_affix_sortkey(); CREATE UNIQUE INDEX asset_call_number_prefix_once_per_lib ON asset.call_number_prefix (label, owning_lib); CREATE INDEX asset_call_number_prefix_sortkey_idx ON asset.call_number_prefix (label_sortkey); INSERT INTO asset.call_number_prefix (id, owning_lib, label) VALUES (-1, 1, ''); @@ -315,7 +315,7 @@ CREATE TABLE asset.call_number_suffix ( label TEXT NOT NULL, -- i18n label_sortkey TEXT ); -CREATE TRIGGER suffix_normalize_tgr ON asset.call_number_suffix BEFORE INSERT OR UPDATE FOR EACH ROW EXECUTE asset.normalize_affix_sortkey(); +CREATE TRIGGER suffix_normalize_tgr BEFORE INSERT OR UPDATE ON asset.call_number_suffix FOR EACH ROW EXECUTE asset.normalize_affix_sortkey(); CREATE UNIQUE INDEX asset_call_number_suffix_once_per_lib ON asset.call_number_suffix (label, owning_lib); CREATE INDEX asset_call_number_suffix_sortkey_idx ON asset.call_number_suffix (label_sortkey); INSERT INTO asset.call_number_suffix (id, owning_lib, label) VALUES (-1, 1, ''); -- 2.11.0