From: Galen Charlton Date: Tue, 24 Jul 2012 19:31:08 +0000 (-0400) Subject: use PL/PerlU rather than PL/Perl X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=f88836fd0f097afedf51008e95a388f6b3afba63;hp=66620b64f7d28ec1294258594d458697258d722e use PL/PerlU rather than PL/Perl The trusted version of PL/Perl is not enabled by default if you follow the installation instructions for recent versions of Evergreen. Signed-off-by: Galen Charlton --- diff --git a/sql/base/base.sql b/sql/base/base.sql index deeaa3c..35831e0 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -622,7 +622,7 @@ CREATE OR REPLACE FUNCTION migration_tools.expand_barcode (TEXT, TEXT, INTEGER, return $barcode if (length($prefix) + length($new_barcode) + length($suffix)) > $maxlen; return "$prefix$new_barcode$suffix"; -$$ LANGUAGE PLPERL STABLE; +$$ LANGUAGE PLPERLU STABLE; CREATE OR REPLACE FUNCTION migration_tools.attempt_cast (TEXT,TEXT,TEXT) RETURNS RECORD AS $$ DECLARE @@ -729,7 +729,7 @@ CREATE OR REPLACE FUNCTION migration_tools.add_codabar_checkdigit (TEXT) RETURNS my $remainder = $total % 10; my $checkdigit = ($remainder == 0) ? $remainder : 10 - $remainder; return $barcode . $checkdigit; -$$ LANGUAGE PLPERL STRICT STABLE; +$$ LANGUAGE PLPERLU STRICT STABLE; CREATE OR REPLACE FUNCTION migration_tools.attempt_phone (TEXT,TEXT) RETURNS TEXT AS $$ DECLARE