I've gone through the same journey myself. Tried to juggle dlls etc. Apparently python 2 is no longer included in the windows installer.
Since I have lots of python 2.x code with native extensions etc, I thought about compiling postgres from source on Windows but as usual the process turned into a nightmare (compiling anything on Windows is, at least for me) There is also the problem of postgres distribution on windows using the activestate version of python distribution instead of the python.org one if my memory is not failing me.
Anyway, I ended up using virtualbox with linux guest because of this issue. If there is an easy way to get python 2.x(7?) working with postgres on windows, it would be nice to hear.
I've had some issues with how the procedural languages are packaged in the Windows installer for a while, but I was very surprised to see that plpython2 appears to be entirely absent in 9.3.
It doesn't seem to be provided via EDB's StackBuilder app either.
What's going on? It looks like it was dropped in 9.1.
PL/Python 2 and PL/Python 3 are different things. You can't just upgrade trivially from plpython2 to plpython3.
Python 2 and Python 3 install side-by-side without issues.
Why isn't plpython2.dll built and included?
It's good to see that the required procedural language runtime versions are now included in "installation-notes.html" in the installer, though. Thanks for that.
(Any thoughts on my prior question about using virtual service accounts on Windows 7, btw?) -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
