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.msi http://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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
