<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<STYLE style="DISPLAY: none" type=text/css>@font-face {
font-family: o365IconsIE8;
}
@font-face {
font-family: o365IconsMouse;
}
P {
MARGIN-BOTTOM: 0px; MARGIN-TOP: 0px
}
.ms-cui-menu {
FONT-SIZE: 10pt; BORDER-TOP: rgb(166,166,166) 1px solid; FONT-FAMILY: 'Segoe UI WPC','Segoe UI',Tahoma,'Microsoft Sans Serif',Verdana,sans-serif; BORDER-RIGHT: rgb(166,166,166) 1px solid; BORDER-BOTTOM: rgb(166,166,166) 1px solid; COLOR: rgb(51,51,51); BORDER-LEFT: rgb(166,166,166) 1px solid; BACKGROUND-COLOR: #ffffff
}
.ms-cui-menusection-title {
DISPLAY: none
}
.ms-cui-ctl {
VERTICAL-ALIGN: text-top; COLOR: rgb(51,51,51); TEXT-DECORATION: none
}
.ms-cui-ctl-on {
BACKGROUND-COLOR: rgb(205,230,247); opacity: 0.8
}
.ms-cui-img-cont-float {
MARGIN-TOP: 2px; DISPLAY: inline-block
}
.ms-cui-smenu-inner {
PADDING-TOP: 0px
}
.ms-owa-paste-option-icon {
VERTICAL-ALIGN: middle !important; PADDING-BOTTOM: 2px; MARGIN: 0px 6px; DISPLAY: inline-block
}
.ms-rtePasteFlyout-option:hover {
BACKGROUND-COLOR: rgb(205,230,247); opacity: 1
}
.ms-rtePasteFlyout-option {
OUTLINE-WIDTH: medium; PADDING-BOTTOM: 8px; PADDING-TOP: 8px; OUTLINE-STYLE: none; PADDING-LEFT: 4px; OUTLINE-COLOR: invert; PADDING-RIGHT: 4px
}
.ms-cui-menusection {
OVERFLOW: hidden; HEIGHT: 24px; FLOAT: left; WIDTH: 85px
}
.wf {
FONT-VARIANT: normal; VERTICAL-ALIGN: middle; TEXT-TRANSFORM: none; FONT-WEIGHT: normal; DISPLAY: inline-block; speak: none; -webkit-font-smoothing: antialiased
}
.wf-family-owa {
FONT-FAMILY: 'o365Icons'
}
.wf-family-owa {
FONT-FAMILY: 'o365IconsMouse'
}
.ie8 .wf-family-owa {
FONT-FAMILY: 'o365IconsIE8'
}
.ie8 .wf-owa-play-large:before {
}
.notIE8 .wf-owa-play-large:before {
}
.ie8 .wf-owa-play-large {
COLOR: #ffffff
}
.notIE8 .wf-owa-play-large {
BOX-SIZING: border-box; BORDER-TOP: #ffffff 0.1em solid; HEIGHT: 1.4em; BORDER-RIGHT: #ffffff 0.1em solid; BORDER-BOTTOM: #ffffff 0.1em solid; COLOR: #ffffff; PADDING-BOTTOM: 0.1em; TEXT-ALIGN: center; PADDING-TOP: 0.1em; PADDING-LEFT: 0.1em; BORDER-LEFT: #ffffff 0.1em solid; PADDING-RIGHT: 0.1em; WIDTH: 1.4em; border-radius: .8em; -moz-box-sizing: border-box
}
.ie8 .wf-size-play-large {
FONT-SIZE: 30px; HEIGHT: 40px; WIDTH: 40px
}
.notIE8 .wf-size-play-large {
FONT-SIZE: 30px; HEIGHT: 40px; WIDTH: 40px
}
.notIE8 .wf-owa-triangle-down-small:before {
}
.ie8 .wf-owa-triangle-down-small:before {
}
.ie8 .wf-owa-triangle-down-small {
COLOR: #666666
}
.wf-size-x20 {
FONT-SIZE: 20px !important
}
</STYLE>
<META name=GENERATOR content="MSHTML 10.00.9200.17028"></HEAD>
<BODY dir=ltr>
<DIV dir=ltr align=left><SPAN class=505053403-17072014><FONT color=#0000ff
size=2 face=Arial>Not that I know of. I'm not sure why they bother
including the extension files for plpython2 but not the dll. A bit
confusing.</FONT></SPAN></DIV><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 V.
Mather<BR><B>Sent:</B> Wednesday, July 16, 2014 11:32 PM<BR><B>To:</B> 'PostGIS
Users Discussion'; 'CyrilPoitevin'<BR><B>Subject:</B> Re: [postgis-users] A
question on PostGIS Cookbook<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV id=OWAFontStyleDivID
style="FONT-SIZE: 12pt; FONT-FAMILY: Calibri,Arial,Helvetica,sans-serif; COLOR: #000000; BACKGROUND-COLOR: #ffffff">
<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-SIZE: 13px; FONT-FAMILY: Tahoma">
<DIV style="FONT-SIZE: 13px; FONT-FAMILY: Tahoma">
<DIV style="FONT-SIZE: 13px; FONT-FAMILY: Tahoma">
<DIV class=WordSection1>
<P class=MsoNormal><IMG hspace=12 alt=http://sig.cmparks.net/cmp-ms-90x122.png
align=left src="http://sig.cmparks.net/cmp-ms-90x122.png" width=90 height=122
NOSEND="1"> <SPAN
style="FONT-SIZE: 14pt; FONT-FAMILY: 'Arial','sans-serif'; COLOR: #006c56">Stephen
V. Mather<BR></SPAN><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Arial','sans-serif'; COLOR: #006c56">GIS
Manager<BR></SPAN><SPAN
style="FONT-SIZE: 9pt; FONT-FAMILY: 'Arial','sans-serif'; COLOR: #006c56">(216)
635-3243 (Work) </SPAN><SPAN
style="FONT-SIZE: 11pt; FONT-FAMILY: 'Calibri','sans-serif'; COLOR: #1f497d"><A
tabIndex=0 href="http://www.clemetparks.com"
target=_blank><SPAN><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
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></DIV></DIV></DIV></BODY></HTML>