I'm running into the same issue. I can "create language plperl;"
successfully, but as soon as I try to create a function (as shown above),
Postgres dies.
Guimaraes - did you find a solution using standard installers?
sachin - have you tried on win7?
pasman - what's the process to install from source?
More detail on my setup...
I'm on Win7.
Postgres 9.1 32-bit:
http://www.enterprisedb.com/products/pgdownload.do#windows (version 9.1.2-1)
Perl 5.14 32-bit, I've tried both:
http://downloads.activestate.com/ActivePerl/releases/5.14.2.1402/ActivePerl-5.14.2.1402-MSWin32-x86-295342.msihttp://downloads.activestate.com/ActivePerl/releases/5.14.1.1401/ActivePerl-5.14.1.1401-MSWin32-x86-294969.msi
Here's what I see in the log file:
2011-12-21 08:10:49 PST LOG: server process (PID 7296) was terminated by
exception 0xC0000005
2011-12-21 08:10:49 PST HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2011-12-21 08:10:49 PST LOG: terminating any other active server processes
2011-12-21 08:10:49 PST WARNING: terminating connection because of crash of
another server process
2011-12-21 08:10:49 PST DETAIL: The postmaster has commanded this server
process to roll back the current transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
2011-12-21 08:10:49 PST HINT: In a moment you should be able to reconnect
to the database and repeat your command.
2011-12-21 08:10:49 PST LOG: all server processes terminated;
reinitializing
2011-12-21 08:10:59 PST FATAL: pre-existing shared memory block is still in
use
2011-12-21 08:10:59 PST HINT: Check if there are any old server processes
still running, and terminate them.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/BUG-6204-Using-plperl-functions-generate-crash-tp4802111p5092359.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
