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),
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:
Here's what I see in the log file:
2011-12-21 08:10:49 PST LOG: server process (PID 7296) was terminated by
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;
2011-12-21 08:10:59 PST FATAL: pre-existing shared memory block is still in
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.
In response to
pgsql-bugs by date
|Next:||From: marc||Date: 2011-12-21 16:32:25|
|Subject: BUG #6350: Delete a role which is still in use|
|Previous:||From: Alvaro Herrera||Date: 2011-12-21 16:25:53|
|Subject: Re: BUG #6348: PROBLEMAS DELETE|