From e61319d61dfd9f7a420738e4fa690bc4703dc21d Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 2 Mar 2011 15:35:04 -0500 Subject: [PATCH] Correct TRIGGER syntax. Again. --- 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 6115d1c807..965bc96b23 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 BEFORE INSERT OR UPDATE ON asset.call_number_prefix 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 PROCEDURE 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 BEFORE INSERT OR UPDATE ON asset.call_number_suffix 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 PROCEDURE 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