<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">Mostly fine in principle: what’s the support situation w/ 9.1 in pgsql? when is it moving to unsupported?</div> <div id="bloop_sign_1448845219834305024" class="bloop_sign">
<title></title>
<div>
<br>
</div>
-- <br>
Paul Ramsey<br>
http://cleverelephant.ca<div>http://postgis.net
</div>
<script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": "em",
"name": "John Doe",
"jobTitle": "Graduate research assistant",
"affiliation": "University of Dreams",
"additionalName": "Johnny",
"url": "http://www.example.com",
"address": {
"@type": "PostalAddress",
"streetAddress": "1234 Peach Drive",
"addressLocality": "Wonderland",
"addressRegion": "Georgia"
}
}
</script>
</div> <br><p style="color:#000;">On November 27, 2015 at 11:37:12 PM, Paragon Corporation (<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>Why do I want to ditch 9.1 in 2.3?<br><br>1) In 2.3, were are going to have to support 9.6, 9.5, 9.4, 9.3, 9.2<br>(actually I'd like to ditch 9.2 too but two in a row seems harsh). That's 5<br>versions mind you (and 9.1 would make that 6), which means we probably have<br>lots of crap lying around handling old postgres apis instead of using newer<br>apis, just to compensate for supporting older version. I think the real<br>droppers come at 9.2, but 2 in a row might be too much for some folks.<br><br>2) GUC junk has changed overtime. In fact I think pramsey had to copy in<br>some GUC logic from newer PostgreSQL to compensate for the fact that piece<br>he needed is not exposed until later versions of PostgreSQL (I forget if the<br>new functionality was in 9.2 or 9.3) -- Paul you remember? As I recall it<br>was 9.3 that the change happened but maybe other changes happened in 9.2 or<br>9.1<br>3) Side note -- I guess I got to figure this out -- but the new matrix job<br>I setup on Debbie for PostGIS trunk to test 9.6,9.5, 9.4, 9.3, 9.2, 9.1 (<br>does not like 9.1)<br>Fails on the backend problem. <br><br>PostgreSQL version: PostgreSQL 9.1.19 -<br>http://debbie.postgis.net:8080/job/PostGIS_Regress/2343/consoleFull<br><br><br>sfcgal/empty .. failed (diff expected obtained:<br>/var/lib/jenkins/workspace/postgis/tmp/2_3_pg9.1w64/test_107_diff)<br>----------------------------------------------------------------------------<br>-<br>--- sfcgal/empty_expected 2015-11-28 06:43:43.982199307 +0000<br>+++ /var/lib/jenkins/workspace/postgis/tmp/2_3_pg9.1w64/test_107_out<br>2015-11-28 06:46:16.046248495 +0000<br>@@ -1,3 +1,4 @@<br>+ERROR: unrecognized configuration parameter "postgis.backend"<br> T1.1|POINT EMPTY<br> T1.2|LINESTRING EMPTY<br> T1.3|SRID=4326;POLYGON EMPTY<br>@@ -30,7 +31,7 @@<br> ST_Intersection(empty, empty) == empty|t<br> ST_Difference(geometry, empty) == geometry|t<br> ST_Difference(empty, geometry) == empty|t<br>-ST_Distance(geometry, empty) == NULL|inf<br>+ST_Distance(geometry, empty) == NULL|<br> ST_DWithin(geometry, empty, tolerance) == FALSE|f<br> ST_Within(geometry, empty) == FALSE|f<br> ST_Contains(empty, geometry) == FALSE|f<br>----------------------------------------------------------------------------<br>-<br> sfcgal/geography .. failed (diff expected obtained:<br>/var/lib/jenkins/workspace/postgis/tmp/2_3_pg9.1w64/test_108_diff)<br><br><br>What's troubling me is why it works on the old non-matrix job unless I had<br>that setup wrong (like it wasn't testing sfcgal for 9.1) and since I have<br>standardized everything else to be the same except for pg version the issue<br>shows.<br><br>Also seems to work on 9.6,9.5, 9.4,9.3 and 9.2 so took out 9.1 for now<br>until I can isolate the issue or we decide to ditch 9.1 in PostGIS 2.3<br><br>Thanks,<br>Regina<br><br><br>_______________________________________________<br>postgis-devel mailing list<br>postgis-devel@lists.osgeo.org<br>http://lists.osgeo.org/mailman/listinfo/postgis-devel</div></div></span></blockquote></body></html>