Обсуждение: How to install PL/perlU (perl untrusted)

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

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