PostGIS spatial operators not available in CI test environment

[kbighorse]

Summary

PostGIS spatial operator tests fail in the GitHub Actions CI environment with the error:

no spatial operator found for 'st_within': opfamily 23841 type 23725

Affected Tests

The following tests are currently skipped due to this issue:

• tests/test_ogc.py::test_ogc_locations_items_bbox - Uses bbox filtering
• tests/test_ogc.py::test_ogc_polygon_within_filter - Uses ST_Within via CQL2 filter

Root Cause

The PostGIS container used in CI (postgis/postgis:17-3.5) may not have spatial indexes properly initialized, or there's a version mismatch between the PostGIS operators and the spatial reference system.

Potential Solutions

1. Update CI PostGIS initialization - Ensure spatial indexes are properly created after PostGIS extension installation
2. Use a different PostGIS image - Try an older stable version that doesn't have this issue
3. Add explicit GIST index creation - Create spatial indexes on the geometry columns during test database setup
4. Investigate opfamily/type mismatch - The error suggests a catalog mismatch that may require SELECT PostGIS_Extensions_Upgrade();

References

• PR Chemistry relationships should enforce parent-child integrity #416 - Tests were skipped as a workaround
• PostGIS issue tracker may have similar reports for version 3.5