Re: Dynamic loading of Perl Code in Postgres functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Dynamic loading of Perl Code in Postgres functions
Дата
Msg-id 26320.1168983160@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Dynamic loading of Perl Code in Postgres functions  ("Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>)
Ответы Re: Dynamic loading of Perl Code in Postgres functions  ("Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>)
Список pgsql-general
"Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com> writes:
> I was just wondering if one could use something like this

> CREATE FUNCTION *funcname* (*argument-types*) RETURNS *return-type* AS $$
>     require "abc.pl"
> $$ LANGUAGE plperl;

You'd have to use plperlu, since "require" isn't considered a trusted
operation.

> To include abc.pl here, how is the path of abc.pl specified.

Same as you'd do it in plain Perl.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Nathan Bell
Дата:
Сообщение: 8.1 vs 8.2.1 view optimization
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.1 vs 8.2.1 view optimization