Add support for PostGIS 3.5

[David Smith]

​PostGIS 3.5 was released on 26 September 2024.

My initial try showed that there is one test failure when using this new version that needs to be investigated.

======================================================================
ERROR: test_relate_lookup (gis_tests.geoapp.tests.GeoLookupTest.test_relate_lookup)
Testing the 'relate' lookup type.
----------------------------------------------------------------------
Traceback (most recent call last):
  File "C:\Users\smith\projects\django\tests\gis_tests\geoapp\tests.py", line 581, in test_relate_lookup
    "Lawrence", City.objects.get(point__relate=(ks.poly, within_mask)).name
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\smith\projects\django\django\db\models\manager.py", line 87, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\Users\smith\projects\django\django\db\models\query.py", line 633, in get
    raise self.model.DoesNotExist(
gis_tests.geoapp.models.City.DoesNotExist: City matching query does not exist.

[Natalia Bidart]

​PR to run tests with PostGIS 3.5 (test pass) via a label-triggered GH action.

[GitHub <noreply@…>]

In 8c56e939:

Refs #36009 -- Added GitHub action workflow to run tests with latest stable postgis version.

[David Smith]

The test_relate_lookup is failing with PostGIS, and (I'm fairly sure) with GEOS 3.13+. PostGIS made a change to the way "relate" works when GEOS 3.13 is available so I'm guessing this is relavent ​https://trac.osgeo.org/postgis/ticket/5770. PostGIS will now use the new implementation for "relate" which is available in GEOS 3.13. ​see docs on RelateNG

Running the tests with --debug-sql, I get the output ​seen here. Happy to post to trac, but the "wkb" for Kansas is quite big.

If I connect to the database, load the values for Lawrence and run the same query, I get one result (Lawrence). However, that same query being run by Django's returns 0 results. I'm unsure how to continue to debug this.

insert into geoapp_city values
(1, 'Lawrence', 'POINT (-95.235060 38.971823)')

[Natalia Bidart]

Thank you David for the debugging information. One thing I'm not sure I follow is:

• test_relate_lookup works with PostGIS 3.5 and GEOS 3.9 (this is the confg in the new GHA workflow), but
• test_relate_lookup fails with PostGIS 3.5 and GEOS 3.13 (this is the failure posted in this ticket).

Given the above, and given than RelateNG is provided by GEOS and its implementation changed in 3.13, shouldn't the issue be that we need to (re) confirm support for GEOS 3.13? Seems like we should close this ticket as fixed and re-open #35775.

[nessita <124304+nessita@…>]

In d0113c17:

Refs #36009 -- Adjusted gis_tests.geoapp.tests.GeoLookupTest.test_relate_lookup for bug in PostGIS.

ST_Relate() with PostGIS 3.5 and GEOS 3.13 gives a different result when
a series of calls are made vs. single call of the same function.

The fix for this is expected to be released in PostGIS 3.5.4 and 3.6.0.

​https://lists.osgeo.org/pipermail/postgis-devel/2025-July/030581.html
​https://trac.osgeo.org/postgis/ticket/5938

[nessita <124304+nessita@…>]

In 1909108:

Fixed #36009 -- Confirmed support for PostGIS 3.5.