Thread: createlang plperl

createlang plperl

From
"Jennifer Lee"
Date:
Hello,

I'm running cygwin 1.2.21, postgresql 7.3.2 on Windows XP and was
trying to add plperl to my databases with

> createlang plperl template1

I got this error message:
ERROR:  Load of file /usr/lib/postgresql/plperl.dll failed: dlopen:
Win32 error 126
createlang: language installation failed

I was able to add plpgsql and plpython with the above command
without any problems. Can anyone tell me if it's a problem with the file
or if I'm doing something wrong. I've just installed this recently and
everything else seems to be working fine so far. I wasn't sure if this is
a cygwin, Windows, or postgresql problem. Thanks for any help.

Cheers,
Jennifer


Re: createlang plperl

From
Jason Tishler
Date:
Jennifer,

On Fri, Mar 14, 2003 at 12:33:56PM +0000, Jennifer Lee wrote:
> > createlang plperl template1
>
> I got this error message:
> ERROR:  Load of file /usr/lib/postgresql/plperl.dll failed: dlopen:
> Win32 error 126
> createlang: language installation failed

Note the following:

    $ fgrep 126L /usr/include/w32api/winerror.h
    #define ERROR_MOD_NOT_FOUND 126L
    ...

Install perl 5.8.0-1 to fix the above.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

Re: createlang plperl

From
"Jennifer Lee"
Date:
Will do then, thanks so much for the help.
jennifer

> Jennifer,
>
> On Fri, Mar 14, 2003 at 12:33:56PM +0000, Jennifer Lee wrote:
> > > createlang plperl template1
> >
> > I got this error message:
> > ERROR:  Load of file /usr/lib/postgresql/plperl.dll failed: dlopen:
> > Win32 error 126 createlang: language installation failed
>
> Note the following:
>
>     $ fgrep 126L /usr/include/w32api/winerror.h
>     #define ERROR_MOD_NOT_FOUND 126L
>     ...
>
> Install perl 5.8.0-1 to fix the above.
>
> Jason
>
> --
> PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
> Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster