I'm kind of confused how this require thing would actually work
because I tried testing it at my end at its really not working with
postgres.
I'm sure there is some fundamental mistake.
I have to do the following:
I have a perl file and need to call and use full functionaily of
this perl file in my postgres function.
For this, the create function script that I wrote is as follows:
CREATE FUNCTION test_perl (int) RETURNS int AS $$
require 'email_parser1.pl'
$$ LANGUAGE plperlu;
really don't know if this is correct because if i try to load a file
that doesn't exist atall, then also postgres doesn't throw any errors.
Also do i need to give the fully qualified path of the perl file in
the create function script?
A quick help would be highly appreciated as I'm badly stuck up here.
Thanks,
Jas
On 1/16/07, Harpreet Dhaliwal <harpreet.dhaliwal01@xxxxxxxxx> wrote:
so my syntax is correct? just wondering if there's some fundamental mistake
in it
~Harpreet
On 1/16/07, Tom Lane < tgl@xxxxxxxxxxxxx> wrote:
> "Harpreet Dhaliwal" < harpreet.dhaliwal01@xxxxxxxxx> 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
>
