<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} .ms-cui-menu {background-color:#ffffff;border:1px rgb(166, 166, 166) solid;font-family:'Segoe UI WPC','Segoe UI',Tahoma,'Microsoft Sans Serif',Verdana,sans-serif;font-size:10pt;color:rgb(51, 51, 51);} .ms-cui-menusection-title {display:none;} .ms-cui-ctl {vertical-align:text-top;text-decoration:none;color:rgb(51, 51, 51);} .ms-cui-ctl-on {background-color:rgb(205, 230, 247);opacity: 0.8;} .ms-cui-img-cont-float {display:inline-block;margin-top:2px} .ms-cui-smenu-inner {padding-top:0px;} .ms-owa-paste-option-icon {margin: 0px 6px 0px 6px;vertical-align:middle!important;padding-bottom: 2px;display:inline-block;} .ms-rtePasteFlyout-option:hover {background-color:rgb(205, 230, 247) !important;opacity:1 !important;} .ms-rtePasteFlyout-option {padding:8px 4px 8px 4px;outline:none;} .ms-cui-menusection {float:left; width:85px;height:24px;overflow:hidden}.wf {speak:none; font-weight:normal; font-variant:normal; text-transform:none; -webkit-font-smoothing:antialiased; vertical-align:middle; display:inline-block;}.wf-family-owa {font-family:'o365Icons'}@font-face { font-family:'o365IconsIE8'; src:url('https://r4.res.outlook.com/owa/prem/16.0.298.15/resources/styles/office365icons.ie8.eot?#iefix') format('embedded-opentype'), url('https://r4.res.outlook.com/owa/prem/16.0.298.15/resources/styles/office365icons.ie8.woff') format('woff'), url('https://r4.res.outlook.com/owa/prem/16.0.298.15/resources/styles/office365icons.ie8.ttf') format('truetype'); font-weight:normal; font-style:normal;}@font-face { font-family:'o365IconsMouse'; src:url('https://r4.res.outlook.com/owa/prem/16.0.298.15/resources/styles/office365icons.mouse.eot?#iefix') format('embedded-opentype'), url('https://r4.res.outlook.com/owa/prem/16.0.298.15/resources/styles/office365icons.mouse.woff') format('woff'), url('https://r4.res.outlook.com/owa/prem/16.0.298.15/resources/styles/office365icons.mouse.ttf') format('truetype'); font-weight:normal; font-style:normal;}.wf-family-owa {font-family:'o365IconsMouse'}.ie8 .wf-family-owa {font-family:'o365IconsIE8'}.ie8 .wf-owa-play-large:before {content:'\e254';}.notIE8 .wf-owa-play-large:before {content:'\e054';}.ie8 .wf-owa-play-large {color:#FFFFFF/*$WFWhiteColor*/;}.notIE8 .wf-owa-play-large {border-color:#FFFFFF/*$WFWhiteColor*/; width:1.4em; height:1.4em; border-width:.1em; border-style:solid; border-radius:.8em; text-align:center; box-sizing:border-box; -moz-box-sizing:border-box; padding:0.1em; color:#FFFFFF/*$WFWhiteColor*/;}.ie8 .wf-size-play-large {width:40px; height:40px; font-size:30px}.notIE8 .wf-size-play-large {width:40px; height:40px; font-size:30px}.notIE8 .wf-owa-triangle-down-small:before {content:'\e052';}.ie8 .wf-owa-triangle-down-small:before { content:'\e052';}.ie8 .wf-owa-triangle-down-small {color:#666666/*$WFGreyColor*/;}.wf-size-x20 {font-size: 20px!important;}--></style>
</head>
<body dir="ltr">
<div id="OWAFontStyleDivID" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>Hi Regina,</p>
<p><br>
</p>
<p>Are there 9.3 versions compiled by others for Windows that are compiled with Python 2?</p>
<p><br>
</p>
<p>Thanks,<br>
</p>
<p>Best,</p>
<p>Steve<br>
</p>
<div>
<p><br>
</p>
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div class="WordSection1">
<p class="MsoNormal"><img alt="http://sig.cmparks.net/cmp-ms-90x122.png" align="left" height="122" hspace="12" width="90" src="http://sig.cmparks.net/cmp-ms-90x122.png">
<span style="font-size:14.0pt; font-family:"Arial","sans-serif"; color:#006C56">Stephen V. Mather<br>
</span><span style="font-size:11.0pt; font-family:"Arial","sans-serif"; color:#006C56">GIS Manager<br>
</span><span style="font-size:9.0pt; font-family:"Arial","sans-serif"; color:#006C56">(216) 635-3243 (Work)
</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"><a target="_blank" href="http://www.clemetparks.com" tabindex="0"><span style=""><br>
clevelandmetroparks.com</span></a></span></p>
<p class="MsoNormal"></p>
<br>
<br>
<br>
</div>
</div>
<div></div>
</div>
</div>
</div>
<div style="color: rgb(33, 33, 33);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size:11pt" color="#000000" face="Calibri, sans-serif"><b>From:</b> postgis-users-bounces@lists.osgeo.org <postgis-users-bounces@lists.osgeo.org> on behalf of Paragon Corporation <lr@pcorp.us><br>
<b>Sent:</b> Wednesday, July 16, 2014 11:28 PM<br>
<b>To:</b> 'PostGIS Users Discussion'; 'Cyril Poitevin'<br>
<b>Subject:</b> Re: [postgis-users] A question on PostGIS Cookbook</font>
<div> </div>
</div>
<div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2">Regarding the Python versions for windows</font></span></div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2">For PostgreSQL 9.2+ EDB only supports plpython3u</font></span></div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2">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" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2">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" face="Arial" size="2">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" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2">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" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2">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" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2"><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" face="Arial" size="2"></font></span> </div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2">Hope that helps,</font></span></div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2">Regina</font></span></div>
<div dir="ltr" align="left"><span class="476192003-17072014"><font color="#0000ff" face="Arial" size="2"><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" face="Arial" size="2"><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" face="Arial" size="2"></font><br>
<div class="OutlookMessageHeader" dir="ltr" align="left" lang="en-us">
<hr tabindex="-1">
<font face="Tahoma" size="2"><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 border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<th align="right" nowrap="" valign="baseline">Objet:</th>
<td>Re: A question on PostGIS Cookbook</td>
</tr>
<tr>
<th align="right" nowrap="" valign="baseline">Date:</th>
<td>15.07.2014 10:08</td>
</tr>
<tr>
<th align="right" nowrap="" valign="baseline">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 align="right" nowrap="" valign="baseline">À:</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>
</div>
</div>
</div>
</body>
</html>