Re: Dynamic loading of Perl Code in Postgres functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
Cc: "John DeSoi" <desoi(at)pgedit(dot)com>, "Jasbinder Singh Bali" <jsbali(at)gmail(dot)com>, "Adam Rich" <adam(dot)r(at)sbcglobal(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Dynamic loading of Perl Code in Postgres functions
Date: 2007-01-16 21:32:40
Message-ID: 26320.1168983160@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-16 21:40:37 Re: 8.1 vs 8.2.1 view optimization
Previous Message Nathan Bell 2007-01-16 21:24:53 8.1 vs 8.2.1 view optimization