Unanswered: Problem installing perl in the database
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()
Trying to compile this in the Pg database I get the error:
Ouverture=# CREATE OR REPLACE FUNCTION TestPerl()
Ouverture-# RETURNS INTEGER
Ouverture-# LANGUAGE plperlu
Ouverture-# AS $$
Ouverture$# return 1
ERROR: could not load library "C:/Programmi/PostgreSQL/8.3/lib/plperl.dll": unknown error 126