Re: How to build plperl with PostgreSQL 9 on Windows

[tuanhoanganh <hatuan05@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxx> wrote:

On Tue, Jan 4, 2011 at 19:27, tuanhoanganh <hatuan05@xxxxxxxxx> 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\";