<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.17028"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial>Regarding the Python versions for windows</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial>For PostgreSQL 9.2+ EDB only supports
plpython3u</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial>If you are running 9.2 or 9.3 then you need to install Python
3.2</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial>For 9.4 it looks like they built plpthon with Python
3.3</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial>Also make sure if you installed 32-bit PostgreSQL you use the
32-bit Python and if you installed PostgreSQL 64-bit you install the 64-bit
python.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial>If you use a Python3 higher than what PostgreSQL is compiled
with, it won't work.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial>When in doubt, use dependency walker and open up the
plpython3.dll and it will tell you the version of Python you
need</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.dependencywalker.com/">http://www.dependencywalker.com/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014><FONT color=#0000ff
size=2 face=Arial><A
href="http://postgis.net">http://postgis.net</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=476192003-17072014></SPAN> </DIV><FONT
color=#0000ff size=2 face=Arial></FONT><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Stephen
Mather<BR><B>Sent:</B> Wednesday, July 16, 2014 10:44 PM<BR><B>To:</B> Cyril
Poitevin<BR><B>Cc:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re:
[postgis-users] A question on PostGIS Cookbook<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>
<DIV>No worries Cyril,<BR><BR>Formality always appreciated.<BR></DIV>Try this
for me-- try the "WinnieBot" installs from <A
href="http://postgis.net/windows_downloads">http://postgis.net/windows_downloads</A>
. I'm working on the assumption you are not working (yet) toward a
production version. The ones at this location: <A
href="http://winnie.postgis.net/download/windows/pg94/buildbot/">http://winnie.postgis.net/download/windows/pg94/buildbot/</A>
will also allow you to use all the SFCGAL goodness of the 3D chapter.<BR><BR>I'm
also cc'ing the postgis users group.<BR><BR>Hi all-- best suggestions for
Windows PostGIS installs with 2.x Python? Have the EDB versions of Postgres
switched to 3.x Python?<BR><BR>Thanks,<BR>Best,<BR>Steve<BR><BR><BR>
<DIV><BR><BR></DIV></DIV>
<DIV class=gmail_extra><BR><BR>
<DIV class=gmail_quote>On Tue, Jul 15, 2014 at 4:33 AM, Cyril Poitevin <SPAN
dir=ltr><<A href="mailto:cyril.poitevin@univ-lr.fr"
target=_blank>cyril.poitevin@univ-lr.fr</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><U></U>
<DIV style="FONT-FAMILY: Verdana,Geneva,sans-serif">
<P>Oops "Hi Steve"</P>
<P>Sorry.</P>
<P>-------- Message original --------</P>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TH vAlign=baseline noWrap align=right>Objet:</TH>
<TD>Re: A question on PostGIS Cookbook</TD></TR>
<TR>
<TH vAlign=baseline noWrap align=right>Date:</TH>
<TD>15.07.2014 10:08</TD></TR>
<TR>
<TH vAlign=baseline noWrap align=right>De:</TH>
<TD>Cyril Poitevin <<A href="mailto:cyril.poitevin@univ-lr.fr"
target=_blank>cyril.poitevin@univ-lr.fr</A>></TD></TR>
<TR>
<TH vAlign=baseline noWrap align=right>À:</TH>
<TD>Stephen Mather <<A href="mailto:stephen@smathermather.com"
target=_blank>stephen@smathermather.com</A>></TD></TR></TBODY></TABLE>
<DIV>
<DIV class=h5>
<P> </P>
<P>Hi Stephen,</P>
<P>This is the .exe:</P>
<P>postgresql-9.3.3-1-windows-x64.exe</P>
<P><A title=https://www.sendspace.com/file/6eabi9
href="https://www.sendspace.com/file/6eabi9"
target=_blank>https://www.sendspace.com/file/6eabi9</A></P>
<P>And when you run it, I have this information:</P>
<P>"Packaged by EDB EnterpriseDB"</P>
<P>I have also pgadmin3 1.18.1.</P>
<P>Thanks for your help.</P>
<P>Cyril</P>
<P>Le 15.07.2014 00:56, Stephen Mather a écrit :</P>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid; WIDTH: 100%">
<DIV dir=ltr>
<DIV>Hi Cyril,<BR><BR></DIV>
<DIV>Specifically, which installer did you use for PostgreSQL?<BR><BR></DIV>
<DIV>Best,<BR>Steve<BR><BR><BR></DIV></DIV>
<DIV class=gmail_extra><BR><BR>
<DIV class=gmail_quote>On Mon, Jul 14, 2014 at 4:23 AM, Paolo Corti
<SPAN><<A href="mailto:pcorti@gmail.com"
target=_blank>pcorti@gmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi<BR>as
far as I can remember, on debian/ubuntu PostgreSQL has support for<BR>bot
Python 2.x and Python 3.x. Not being a Windows user I am not<BR>totally
sure what is the situation there.<BR>The default, though, according to the
documentation<BR>(<A
href="http://www.postgresql.org/docs/9.3/static/plpython-python23.html"
target=_blank>http://www.postgresql.org/docs/9.3/static/plpython-python23.html</A>)<BR>should
be Python 2.x for any operating system:<BR><BR>"The language named
plpythonu implements PL/Python based on the<BR>default Python language
variant, which is currently Python 2. (This<BR>default is independent of
what any local Python installations might<BR>consider to be their
"default", for example, what /usr/bin/python<BR>might be.) The default
will probably be changed to Python 3 in a<BR>distant future release of
PostgreSQL, depending on the progress of the<BR>migration to Python 3 in
the Python community."<BR><BR>Now, having said this, I am not sure why on
your windows box the default is 3.2.<BR>Maybe is it just a matter of
installing the correct language name on<BR>your database (plpython2u
instead than plpython3u)?<BR><BR>I am adding Steve in copy, as he is the
author of the Voronoi recipes<BR>and maybe he has some more
suggestions<BR>regards<BR>p<BR><BR>On Fri, Jul 11, 2014 at 6:51 PM, Cyril
Poitevin<BR><<A href="mailto:cyril.poitevin@univ-lr.fr"
target=_blank>cyril.poitevin@univ-lr.fr</A>> wrote:<BR>>
Ciao,<BR>><BR>> I've purchased PostGIS "Cookbook" last february, and
it is really pleasant<BR>> to read. I learned a lot with it. Thanks to
bring a good reference book like<BR>> this for all the
geomaticians.<BR>><BR>> By the way, I have a problem that I can't
solve for the moment, I can't<BR>> reproduce the tutorial to calculate
a voronoi diagram, I need this method in<BR>> my actual job, so it's
quite important.<BR>><BR>> I know you are not the author of this
chapter but maybe you will be able to<BR>> help me or just redirect
myself towards the author of this part.<BR>><BR>> In PostgreSQL 9.3
Windows 64 package, there is no library for linking<BR>> PostgreSQL to
Python 2, only one library to link it with Python 3.2 and It<BR>> seems
all the source code necessary (from geogeek blog or pyhull) have
been<BR>> developed with Python 2.7 so I can't use them. I tried to
convert the code<BR>> from geogeek blog for Python 3 but no success for
the moment.<BR>><BR>> You precise at the beginning of the book to
install the latest version of<BR>> PostgreSQL (9.3) so maybe you have a
solution for using Python 2.7 with<BR>> PostgreSQL 9.3, I don't
find solution on internet for that problem.<BR>><BR>> Thanks in
advance for your help.<BR>><BR>> Kind regards.<BR>><BR>> Cyril
Poitevin - Ingénieur d'étude en traitement de données<BR>> Mail : <A
href="mailto:cyril.poitevin@univ-lr.fr"
target=_blank>cyril.poitevin@univ-lr.fr</A> / Tel : 06 03 48 77 34<BR>>
UMR 7266 / Littoral Environnement et Sociétés (LIENSs)<BR>> 2 rue
Olympe de Gouges 17000 La Rochelle<BR><SPAN><SPAN
style="COLOR: #888888"><BR><BR><BR>--<BR>Paolo Corti<BR>Geospatial
software developer<BR>web: <A href="http://www.paolocorti.net"
target=_blank>http://www.paolocorti.net</A><BR>twitter: @capooti<BR>skype:
capooti<BR></SPAN></SPAN></BLOCKQUOTE></DIV></DIV></BLOCKQUOTE>
<P> </P></DIV></DIV></DIV></BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>