From a722d95d817ef7dc34c5db1340502b8cd48745a4 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 1 Nov 2005 17:57:49 +0000 Subject: [PATCH] adding function to public schema instead of non-existant (at this point in the install) asset schema git-svn-id: svn://svn.open-ils.org/ILS/trunk@1933 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/020.schema.functions.sql | 2 +- Open-ILS/src/sql/Pg/040.schema.asset.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/020.schema.functions.sql b/Open-ILS/src/sql/Pg/020.schema.functions.sql index 1b3682ae92..1d1fbf67f0 100644 --- a/Open-ILS/src/sql/Pg/020.schema.functions.sql +++ b/Open-ILS/src/sql/Pg/020.schema.functions.sql @@ -1,4 +1,4 @@ -CREATE OR REPLACE FUNCTION asset.call_number_dewey( TEXT ) RETURNS TEXT AS $$ +CREATE OR REPLACE FUNCTION public.call_number_dewey( TEXT ) RETURNS TEXT AS $$ my $txt = shift; $txt =~ s/^\s+//o; $txt =~ s/[\[\]\{\}\(\)`'"#<>\*\?\-\+\$\\]+//o; diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index 1e00dd4c90..0a569f5be8 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -121,7 +121,7 @@ CREATE TABLE asset.call_number ( CREATE INDEX asset_call_number_record_idx ON asset.call_number (record); CREATE INDEX asset_call_number_creator_idx ON asset.call_number (creator); CREATE INDEX asset_call_number_editor_idx ON asset.call_number (editor); -CREATE INDEX asset_call_number_dewey_idx ON asset.call_number (asset.call_number_dewey(label)); +CREATE INDEX asset_call_number_dewey_idx ON asset.call_number (public.call_number_dewey(label)); CREATE TABLE asset.call_number_note ( id BIGSERIAL PRIMARY KEY, -- 2.43.2