Re: Shared Objects (Dynamic loading) - Mailing list pgsql-general

From Jasbinder Bali
Subject Re: Shared Objects (Dynamic loading)
Date
Msg-id a47902760608271413j1ec702aeq1f478b3a8489021a@mail.gmail.com
Whole thread Raw
In response to Re: Shared Objects (Dynamic loading)  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Shared Objects (Dynamic loading)
List pgsql-general
Hi,
Can you please give me pointers to how to establish clinet server model using PL/Perl.
I mean how do i give the ip address of the database server in my Perl script running in another machine.
Regards,
Jas

On 8/26/06, Michael Fuhr <mike@fuhr.org> wrote:
On Sat, Aug 26, 2006 at 03:32:37PM -0400, Jasbinder Bali wrote:
> Do we have any concept of shared objects in perl.
> Just wondering, how do we dynamically load something written in perl in
> postgresql.

A PL/Perl function can load external code with "use", "require",
or "do".  Since those are potentially dangerous operations you'll
need to create the function with plperlu, which means you'll need
to create the function as a database superuser.  See "Trusted and
Untrusted PL/Perl" in the documentation for more information.

http://www.postgresql.org/docs/8.1/interactive/plperl-trusted.html

Regarding "use", "require", and "do" see the Perl documentation,
in particular the perlfunc and perlmod manual pages.

--
Michael Fuhr

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Cutting the Gborg throat
Next
From: Michael Fuhr
Date:
Subject: Re: Shared Objects (Dynamic loading)