Re: How to build plperl with PostgreSQL 9 on Windows

I have error when build plperl

1>------ Build started: Project: plperl, Configuration: Release Win32 ------
1>Generate DEF file
1>Not re-generating PLPERL.DEF, file already exists.
1>Linking...
1> Creating library Release\plperl\plperl.lib and object
Release\plperl\plperl.exp
1>SPI.obj : error LNK2019: unresolved external symbol _Perl_Tstack_base_ptr
referenced in function _XS__spi_exec_query
1>Util.obj : error LNK2001: unresolved external symbol _Perl_Tstack_base_ptr
1>SPI.obj : error LNK2019: unresolved external symbol
_Perl_Tmarkstack_ptr_ptr referenced in function _XS__spi_exec_query
1>Util.obj : error LNK2001: unresolved external symbol
_Perl_Tmarkstack_ptr_ptr
1>SPI.obj : error LNK2019: unresolved external symbol _Perl_Tstack_sp_ptr
referenced in function _XS__spi_exec_query
1>Util.obj : error LNK2001: unresolved external symbol _Perl_Tstack_sp_ptr
1>Util.obj : error LNK2019: unresolved external symbol _Perl_Tcurpad_ptr
referenced in function _XS___aliased_constants
1>Util.obj : error LNK2019: unresolved external symbol _Perl_Top_ptr
referenced in function _XS___aliased_constants
1>.\Release\plperl\plperl.dll : fatal error LNK1120: 5 unresolved externals

My ActivePerl version :"This is perl, v5.10.1 built for
MSWin32-x86-multi-thread"

How to fix it?

Please help me. Thanks in advance

Tuan Hoang ANh

On Wed, Jan 5, 2011 at 10:32 AM, tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:

> Thanks you very much
> Here is my config.pl
> $config->{perl} = "c:\\perl";
> 1;
>
> Strawberry Perl don't work because It don't have perl lib in
> c:\Perl\lib\CORE\.
> I swiched to ActivePerl to build plperl.Bu
>
> Tuan Hoang ANh
>
>
> On Wed, Jan 5, 2011 at 9:52 AM, Alex Hunsaker <badalex(at)gmail(dot)com> wrote:
>
>> On Tue, Jan 4, 2011 at 19:27, tuanhoanganh <hatuan05(at)gmail(dot)com> wrote:
>> > Thanks for answer me but it have error
>> >
>> > Detected Visual Studio version 8.00
>> > Detected hardware platform: Win32
>> > Generating win32ver.rc for src\backend
>> > Building src\pl\plperl\SPI.c...
>> > '1' is not recognized as an internal or external command,
>>
>> Instead of 1, try the path to the perl directory (such that
>> $config->{'perl'} . "\bin\perl" is the perl binary). For example:
>> $config->{perl} = "C:\strawberry\perl\";
>>
>
>