Re: plperl.dll error from create langauge plperl (XP Pro 64 bit)

Doug Knight wrote:
> Doug
> On Fri, 2007-11-09 at 15:35 -0500, Andrew Dunstan wrote:
>>
>> Doug Knight wrote:
>> > All,
>> > I am building an XP Pro 64 bit system, where I have installed the 
>> > latest PostgreSQL binary distribution (8.2.5-1). Everything loaded 
>> > fine, I have postgres up and running as a service, installed ActiveTcl 
>> > and ActivePerl, enabled PostGIS, etc. I can do the CREATE LANGUAGE 
>> > 'pgtcl' successfully, but I get the following error when I try to 
>> > CREATE LANGUAGE 'plperl'
>> >
>> > ERROR: could not load library "C:/Program Files 
>> > (x86)/PostgreSQL/8.2/lib/plperl.dll": %1 is not a valid Win32 application.
>> >
>> > Has anyone encountered this error with the binary install in question, 
>> > or has anyone attempted on XP Pro 64 bit? If this is a 32 vs 64 bit 
>> > issue, our plan is to eventually run on a 32 bit version, but 64 bit 
>> > is all I currently have access to.
>> >
>> >
>>
>> It's almost certainly a 32 vs 64 bit issue. Do you have the 32bit or 
>> 64bit perl installed?
>>
>> We have not got support for 64-bit binaries on Windows yet.
>>
> Hi Andrew,
> The ActivePerl is 64 bit. Funny how it didn't affect the ActiveTcl and
> pltcl load. Everything else seems to work fine, just loading the perl lib.

That's your problem right there. ActiveTcl isn't available 64-bit last I
checked, that's why that one works.

32-bit binaries work just fine on xp x64, but you need 32-bit perl.

//Magnus