adding function to public schema instead of non-existant (at this point in the instal...
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 1 Nov 2005 17:57:49 +0000 (17:57 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Tue, 1 Nov 2005 17:57:49 +0000 (17:57 +0000)
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
Open-ILS/src/sql/Pg/040.schema.asset.sql

index 1b3682a..1d1fbf6 100644 (file)
@@ -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;
        my $txt = shift;
        $txt =~ s/^\s+//o;
        $txt =~ s/[\[\]\{\}\(\)`'"#<>\*\?\-\+\$\\]+//o;
index 1e00dd4..0a569f5 100644 (file)
@@ -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_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,
 
 CREATE TABLE asset.call_number_note (
        id              BIGSERIAL                       PRIMARY KEY,