Thread: How to install PL/perlU (perl untrusted)

How to install PL/perlU (perl untrusted)

From
"LLC"
Date:
Hi List;
 
I found documentation that talks about untrusted perl here:
http://www.postgresql.org/docs/8.1/interactive/plperl-trusted.html
 
However I do not know how to install/use untrusted perl.
 
Can someone point me in the right direction?
 
Thanks in advance...

Re: How to install PL/perlU (perl untrusted)

From
Tony Caduto
Date:
LLC wrote:
>
> However I do not know how to install/use untrusted perl.
>
>
the easiest way is to use createlang from the command line.

for PLperlu just do the following:

(run the command as the postgres user)
su postgrest<enter>
Then:
createlang plperlu yourdatabasename

It's pretty much the same on win32, except creatlang may not be in the
path, so you should actually be in the bin
dir when you run it or use the full path name.

Hope this helps,

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration


Re: How to install PL/perlU (perl untrusted)

From
Scott Marlowe
Date:
On Fri, 2006-06-16 at 12:57, LLC wrote:
> Hi List;
>
> I found documentation that talks about untrusted perl here:
> http://www.postgresql.org/docs/8.1/interactive/plperl-trusted.html
>
> However I do not know how to install/use untrusted perl.
>
> Can someone point me in the right direction?
>
> Thanks in advance...
>

Here's a dirt simple shell script to make a set for everything in the
public schema.  It's not pretty, but it seems to work on 7.4.x

echo "create temp sequence tc;SELECT 'set add table (set id=1, origin=1,
id='||nextval('tc')||', fully qualified name =
''public.'||c.relname||'\', comment=\'\');' as \"Name\" FROM
pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_user u ON u.usesysid =
c.relowner LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE n.nspname='public' and c.relkind IN ('r') AND n.nspname NOT IN
('pg_catalog', 'pg_toast') AND pg_catalog.pg_table_is_visible(c.oid)
order by 1;drop sequence tc;"|psql stage_reporting