Re: [GENERAL] plperlu function caused a segmentation fault

2011-08-24 Thread bricklen
On Wed, Aug 24, 2011 at 1:16 PM, Tom Lane wrote: > I agree you probably don't want to poke at this in your production > instance, but you could create a playpen instance (separate data > directory, nondefault port number) using the same executables and > then do your testing there.  If you didn't

Re: [GENERAL] plperlu function caused a segmentation fault

2011-08-24 Thread Tom Lane
bricklen writes: > On Wed, Aug 24, 2011 at 12:11 PM, Alex Hunsaker wrote: >> Hrm, do simple plperlu functions break it? > IIRC, plperl(u) was installed via yum at the same time the db was > upgraded to 9.0.x. It is possible there is more than one Perl version > installed, or that the original Pe

Re: [GENERAL] plperlu function caused a segmentation fault

2011-08-24 Thread bricklen
On Wed, Aug 24, 2011 at 12:11 PM, Alex Hunsaker wrote: > Hrm, do simple plperlu functions break it? I can't tell from your > report if plperlu seems completely broken or if something in your > quoted function seems to be the culprit. > > If > CREATE OR REPLACE FUNCTION plperlu_noop() returns void

Re: [GENERAL] plperlu function caused a segmentation fault

2011-08-24 Thread Alex Hunsaker
On Wed, Aug 24, 2011 at 12:32, bricklen wrote: > On Wed, Aug 24, 2011 at 11:28 AM, Tom Lane wrote: >> I wonder if there is something wonky about your Perl installation. > > I tested originally on two other 9.0.4 databases and there were no > issues at all. I'll have to assume that you are correct

Re: [GENERAL] plperlu function caused a segmentation fault

2011-08-24 Thread bricklen
On Wed, Aug 24, 2011 at 11:28 AM, Tom Lane wrote: > bricklen writes: >> I was just testing a simple plperlu function to return the existence >> of a directory and as soon I pasted the function into psql and hit >> Enter, I got the following crash: > > FWIW, this function seems to work fine for me

Re: [GENERAL] plperlu function caused a segmentation fault

2011-08-24 Thread Tom Lane
bricklen writes: > I was just testing a simple plperlu function to return the existence > of a directory and as soon I pasted the function into psql and hit > Enter, I got the following crash: FWIW, this function seems to work fine for me in 9.0.4 on a Fedora 14 x86_64 box ... and there haven't b

[GENERAL] plperlu function caused a segmentation fault

2011-08-24 Thread bricklen
I was just testing a simple plperlu function to return the existence of a directory and as soon I pasted the function into psql and hit Enter, I got the following crash: CREATE OR REPLACE FUNCTION does_directory_exist(p_path_and_directory TEXT, OUT does_it_exist TEXT) RETURNS TEXT AS $BODY$ my $p