<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>Le 1 oct. 2013 à 04:34, Paragon Corporation a écrit :</div><div><br></div><div>Regina,</div><br><blockquote type="cite">
<meta content="text/html; charset=us-ascii" http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 10.00.9200.16686">
<div style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<div dir="ltr" align="left">
<div><span class="189312302-01102013"><font color="#0000ff" size="2" face="Arial"> > </font></span>So if i hear you, there's a need to
something like postgis_sfcgal extension,</div>
<div><span class="189312302-01102013"><font color="#0000ff" size="2" face="Arial"> > </font></span>in the next 2.2 that's it ?<span class="189312302-01102013"><font color="#0000ff" size="2" face="Arial"> </font></span></div>
<div><span class="189312302-01102013"><font face="Arial"><font color="#0000ff"><font size="2">Correct<span class="439162402-01102013">. I think its too early to demand
people compile with sfcgal (heck I haven't yet and I don't think anyone except
you and Bborie on core PostGIS dev team have).
</span></font></font></font></span></div>
<div><span class="189312302-01102013"><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013">Perhaps in a later release after others
have done it we can fold the 2 into one extension
again.</span></font></font></font></span></div></div></div></blockquote><div><br></div><div>Ok i will create the related ticket </div><br><blockquote type="cite"><div style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"><div dir="ltr" align="left">
<div><span class="189312302-01102013"><strong><font color="#0000ff" size="2" face="Arial"></font></strong></span> <span class="439162402-01102013">> </span>There's something somehow
related in this specific use case:</div></div>
<div><font color="#0000ff" size="2" face="Arial"></font><br></div>
<div> <span class="439162402-01102013">> </span>- You compile PostGIS with
SFCGAL</div>
<div> <span class="439162402-01102013">> </span>- You don't load
sfcgal.sql</div>
<div> <span class="439162402-01102013">> </span>- You choose to force
PostGIS backend to sfcgal</div>
<div> <span class="439162402-01102013">> </span>- You call a function
related to PostGIS backend</div>
<div><font color="#0000ff" size="2" face="Arial"></font><font color="#0000ff" size="2" face="Arial"></font><br></div>
<div><span class="439162402-01102013">> </span>And the result will be something
like 'undefined function'</div>
<div><br><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="439162402-01102013"></span><font face="Arial"><font color="#0000ff"><font size="2">S<span class="439162402-01102013">o are you saying you can't use SFCGAL
functionality unless you load the sfcgal.sql since that contains the
backend call to switch the
backend?</span></font></font></font></span></span></div></div></blockquote><div><br></div><div>Yes new SFCGAL functions (at least in 2.1) need sfcgal.sql load</div><br><blockquote type="cite"><div style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013"></span></font></font></font></span></span> <span class="Apple-style-span" style="color: rgb(0, 0, 255); font-family: Arial; font-size: small; ">What
about the scenario where
you </span></div>
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013">1)
compile with PostGIS with SFCGAL</span></font></font></font></span></span></div>
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013">2)
you just do regular CREATE
EXTENSION?</span></font></font></font></span></span></div>
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013"></span></font></font></font></span></span> </div>
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013">I
presume that will just use GEOS and sfcgal will stay
dormant.</span></font></font></font></span></span></div></div></blockquote><div><br></div><div>Indeed there's 2 kinds of SFCGAL functions: </div><div>the ones switched by postgis.backend and so common with GEOS (e.g ST_Intersects) </div><div>and the brand new ones (e.g ST_Extrude)</div><div><br></div><div>If you don't load sfcgal.sql and don't do anything to switch </div><div>postgis.backend, commons functions will still use GEOS backend,</div><div>and you won't have any extra SFCGAL functions available</div><div><br></div><br><blockquote type="cite"><div style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013">That
would suggest that the </span></font></font></font></span></span></div>
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013"></span></font></font></font></span></span> </div>
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013">CREATE
EXTENSION postgis_sfcgal;</span></font></font></font></span></span></div>
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013"></span></font></font></font></span></span> </div>
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013">should load the functions and switch the
backend. Though not sure how doable that
is.</span></font></font></font></span></span></div></div></blockquote><div><br></div><div>Load the function, obviously yes.</div><div>switch the backend i would say : why so ?</div><div>it's looks like something the user should do by itself if he want/need to...</div><br><blockquote type="cite"><div style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013"></span></font></font></font></span></span> <span class="Apple-style-span" style="color: rgb(0, 0, 255); font-family: Arial; font-size: small; ">On a
separate note Sandro was saying we should have a section in the docs
that describes these GUCS. I believe raster has one as well in
2.2</span></div>
<div><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><span class="Apple-style-span" style="white-space: normal; border-collapse: separate; text-transform: none; word-spacing: 0px; font: normal normal normal medium/normal Helvetica; orphans: 2; widows: 2; letter-spacing: normal; text-indent: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><font face="Arial"><font color="#0000ff"><font size="2"><span class="439162402-01102013">and Sandro and Paul were threatening to create
more for things like ST_Simplify behavior and some other thing like curve
output behavior.</span><span class="439162402-01102013"> </span></font></font></font><br class="Apple-interchange-newline"></span></span></div></div></blockquote><div><br></div><div><br></div><div>Ok do you have something in mind to do so ?</div><div><br></div><div><br></div><div>O.</div></div><div apple-content-edited="true"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></div></span><br class="Apple-interchange-newline"></span><br class="Apple-interchange-newline">
</div>
<br></body></html>