Hello,

My platform is win32 (windows server 2003 se sp1),
I have Postgresql 8.3.7 installed and I am trying to install perl language "untrusted".
Since my machine doesn't have a dev environment (no vc, make etc.)
I've installed ActivePerl, this version:
This is perl, v5.10.1 built for MSWin32-x86-multi-thread.

I've tested the perl installation with a small DBI script which accesses a Oracle database, and it works fine (from the os command line).

Then I've tried to create lang in PG with this command :

createlang plperlu Ouverture

and this *seems* work, in the sense that it returns no errors, but Perl in the db doesn't work. To check this I've written this simple perl test function :

CREATE OR REPLACE FUNCTION TestPerl()
RETURNS INTEGER
STRICT
LANGUAGE plperlu
AS $$
return 1
$$;

Trying to compile this in the Pg database I get the error:

Ouverture=# CREATE OR REPLACE FUNCTION TestPerl()
Ouverture-# RETURNS INTEGER
Ouverture-# STRICT
Ouverture-# LANGUAGE plperlu
Ouverture-# AS $$
Ouverture$# return 1
Ouverture$# $$;
ERROR: could not load library "C:/Programmi/PostgreSQL/8.3/lib/plperl.dll": unknown error 126

I've seen (here: PostgreSQL: Documentation: Manuals: PostgreSQL 8.4: Trusted and Untrusted PL/Perl) that Pg requires a perl compiled with certain flags and define. I've checked and my ActivePerl have them.

So I don't know what else to check ...
Any help and/or ideas would be very appreciated!
Thanks
Bye
Nicola