Comments (6)
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.
from martin.
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.
@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.
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.
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)
- Implement `--preferred-encoding (gzip|brotli)` configuration
- Add `--base-path` CLI option to override the URL path in the tilejson HOT 6
- Website breaks when you click on Jan 1st in the demo
- Add a Tile Preview HOT 1
- How to handle dynamic sources? HOT 2
- For `--auto-bounds quick`, use `ST_EstimatedExtent` instead of `ST_Extent` for quicker results HOT 3
- `Event not found` when starting martin HOT 3
- Add file extension to individual tile URL
- Output valid TileJSON for PostgreSQL Function Sources HOT 2
- Failed local installation due to mismatched types compilation error HOT 1
- What happens when a new materialized view / table added to the database? HOT 1
- Detect old postgresql versions and warn user HOT 2
- version `GLIBC_2.33' not found (required by mbtiles) HOT 6
- martin-cp doc source param HOT 3
- Improve mbtiles diff validation, add new metadata field, usability
- Reduce README, moving more things to the book
- Improve docs with recommended use cases for novice users
- ghcr.io/maplibre/martin:main not found HOT 3
- Fix broken docs links
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from martin.