Giter Site home page Giter Site logo

Comments (6)

sharkAndshark avatar sharkAndshark commented on June 12, 2024

Hi @uxoof You may need to upgrade postgres to 11.x
Martin use query_available_tables.sql to query avaliable table source.

...
JOIN pg_index ix on
                    ix.indrelid = class.oid and
                    ix.indnkeyatts = 1 and -- consider single column indices only
                    attr.attnum = ix.indkey[0]
...

But the pg_index.indnkeyatts was introduced from postgres 11.0. We may need to update our document or support old postgres versions. @nyurik

from martin.

sharkAndshark avatar sharkAndshark commented on June 12, 2024

from martin.

uxoof avatar uxoof commented on June 12, 2024

thanks for your advice, @sharkAndshark . for now, i choose to build martin from git and change "ix.indnkeyatts" with "ix.indnatts" . it works well.

Hopely, next martin releases support PostgreSQL 9.6.

from martin.

nyurik avatar nyurik commented on June 12, 2024

@uxoof granted PG 9.6 was very popular, but you do realize there has been 7 more versions released since then, it has been 8 years since it was first released, and 3 years since it received last update? It might simply be not safe to run due to potential security bugs. See PG versions. I don't mind supporting PG 9.6 if there is a simple enough SQL fix that would support it, but it would be increasingly difficult to support it going forward.

from martin.

nyurik avatar nyurik commented on June 12, 2024

P.S. One important thing we should do is detect PG version and report issues if it is too old. We already do that for postgis, but not for postgresql itself. Tracking in #1230

from martin.

sharkAndshark avatar sharkAndshark commented on June 12, 2024

It would be beneficial if we could extend support to PostgreSQL 9.6 with minor SQL modifications. However, we should not guarantee that in our documentation.

Unable to locate version 9.6 in the Support Matrix.

PostgreSQL version PostGIS 2.5 EOL PostGIS 3.0 PostGIS 3.1 PostGIS 3.2 PostGIS 3.3 PostGIS 3.4 PostGIS 3.5
PostGIS release date 2018/09/23 2019/10/20 2020/12/18 2021/12/18 2022/08/27 2023/08/15 2024/xx/xx
16 No No No No Yes Yes Yes
15 No No No Yes Yes Yes Yes
14 No No Yes Yes Yes Yes Yes
13 No Yes Yes Yes Yes Yes Yes
12 Yes Yes Yes Yes Yes Yes No
11 EOL Yes Yes Yes Yes Yes No No

from martin.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.