Uploaded image for project: 'GeoTools'
  1. GeoTools
  2. GEOT-5527

PostgreSQL 9.6 breaks ASC_OR_DESC for index

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 15.1, 16-beta
    • Fix Version/s: 15.3, 16-RC1
    • Component/s: jdbc-postgis plugin
    • Labels:
      None
    • Environment:

      postgresql-9.6 9.6~rc1-1+b1 / postgresql-9.6-postgis-2.3 2.3.0~rc1+dfsg-1~exp2 on debian unstable (with postgis from experimental)

      Description

      gt-jdbc-postgis tests fail against PostgreSQL 9.6 because most columns of the pg_am table have been removed, causing tests to fail with org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist (see attached logs).

      The fix is included in JDBC driver 9.4.1209 and later:
      https://github.com/pgjdbc/pgjdbc/pull/560
      https://jdbc.postgresql.org/documentation/changelog.html#version_9.4.1209

      I propose that GeoTools master and 15.x be upgraded to 9.4.1211 (latest stable).

        Attachments

          Activity

            People

            • Assignee:
              bencaradocdavies Ben Caradoc-Davies
              Reporter:
              bencaradocdavies Ben Caradoc-Davies
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: