Skip site navigation (1) Skip section navigation (2)

Re: BUG #6204: Using plperl functions generate crash

From: ljwilson <ljwilson(at)digitalav(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6204: Using plperl functions generate crash
Date: 2012-04-19 13:30:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
I began testing PostgreSQL 9.1.x last week, and came across this issue.
Repeatable under the following scenarios (all 32-bit)

1. Windows XP SP3 with latest updates.
2. Windows 7 SP1 with latest updates.
3. Any flavor of Perl 5.1.4.x (I've tried strawberry-perl-,
ActivePerl-, and compiled my own for 5.14.0,
5.14.1, and 5.14.2)
4. postgresql-9.1.0-windows, postgresql-9.1.1-windows,
postgresql-9.1.2-windows, and postgresql-9.1.3-windows from the one-click
5. Compiled postgresql-9.1.3 from source using Windows Platform SDK 7.0.

But here is what will work:
1. Compile postgresql-9.1.3 using mingw32
2. Replace only the plperl.dll the official binaries supply with the
plperl.dll you get from the mingw32 compile
3. Then the test which started this bug discussion works.

This makes me think there is an incompatibility in some environments related
to plperl. I thought maybe it was the version of msvcr90.dll since the
mingw32 compile doesn't link with it. I've got four versions of it on my XP
test box, and have put each version of that dll in my various install
subdirectories (perl\bin, perl\lib, pgsql\bin, pgsql\lib), and none of them
make a difference (assuming it is seeing them "first"). 

My MSVCR90.DLL versions (size)
9.0.21022.8 (655,872 bytes)
9.0.30729.1 (655,872 bytes)
9.0.30729.4148 (653,120 bytes)
9.0.30729.6161 (653,136 bytes)

If it is an environment issue of some kind it would be interesting to know
what locales people have where it works versus where it doesn't. I'm using
the standard ones that the PostgreSQL one-click installer defaults to.

I'd be glad to post the plperl.dll (160,324 bytes) that works for me if
there is a proper place for this kind of thing. Or just compile it from
source yourself using the mingw instructions at


View this message in context:
Sent from the PostgreSQL - bugs mailing list archive at

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2012-04-19 19:00:57
Subject: Re: BUG #6602: concurrent psql session clobbers history
Previous:From: i+pgbugsDate: 2012-04-19 10:02:35
Subject: BUG #6602: concurrent psql session clobbers history

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group