Thread: Pl/Perl w/ Postgres 8.0 on Windows

Hi all,
    I am throughly enjoying using Postgres 8.0 on Windows, so I can
develop my Windows client against Postgres.
I would like to write some pl/perl functions, and I'm a little stumped.
Now comes the sad confession - I installed PG from the Windows installer
rather than building it.  Can I still build pl/perl against it?  Better
yet, is there a pl/perl binary for Windows?

Many thanks,

Eric

> Hi all,
>     I am throughly enjoying using Postgres 8.0 on Windows, so
> I can develop my Windows client against Postgres.
> I would like to write some pl/perl functions, and I'm a
> little stumped.
> Now comes the sad confession - I installed PG from the
> Windows installer rather than building it.  Can I still build
> pl/perl against it?  Better yet, is there a pl/perl binary
> for Windows?

Well, aren't you in luck today :-) The MSI install *always* installs the
plperl DLL. IF you have installed ActiveState perl, it even gives you
the option to enable it in template1 durnig the install.

So you need to:
1) Install ActiveState Perl 5.8, if you haven't already (that's what
it's compiled against)
2) Run "createlang" for PL/Perl, similar as you'd do on Unix.

(2) can be replaced with uninstall/reinstall of the MSI if you haven't
started using your database yet. The option to enable the two plperl
variants should be ungrayed if it finds activeState Perl 5.8 in the
system path.


//Magnus

Thanks to both of you gentlemen.  I actually had to restart Postgres
after installing ActiveState Perl before I could successfully run
createlang and add the language.  Seems to be working now, though.

Cheers,

Eric


Magnus Hagander wrote:

>>Hi all,
>>    I am throughly enjoying using Postgres 8.0 on Windows, so
>>I can develop my Windows client against Postgres.
>>I would like to write some pl/perl functions, and I'm a
>>little stumped.
>>Now comes the sad confession - I installed PG from the
>>Windows installer rather than building it.  Can I still build
>>pl/perl against it?  Better yet, is there a pl/perl binary
>>for Windows?
>>
>>
>
>Well, aren't you in luck today :-) The MSI install *always* installs the
>plperl DLL. IF you have installed ActiveState perl, it even gives you
>the option to enable it in template1 durnig the install.
>
>So you need to:
>1) Install ActiveState Perl 5.8, if you haven't already (that's what
>it's compiled against)
>2) Run "createlang" for PL/Perl, similar as you'd do on Unix.
>
>(2) can be replaced with uninstall/reinstall of the MSI if you haven't
>started using your database yet. The option to enable the two plperl
>variants should be ungrayed if it finds activeState Perl 5.8 in the
>system path.
>
>
>//Magnus
>
>
>
>