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)
- Issues starting the Docker version
- Font endpoint gives 404 but the font seems loaded HOT 2
- HowTo Provide Multiple PG Connections in Config HOT 5
- Tiles are not displayed HOT 1
- add property data to tile HOT 2
- use function with query parameters. How?!
- if it is possible to load postgre function source automatically HOT 2
- uploading tiles slows down extremely HOT 1
- dynamic TileJSONs HOT 3
- very slow queries through martin HOT 11
- Impossible to run when I use PGPool
- Unable to get tile, connection closed
- Error when deploy by AWS Lamda: Unable to load config file .yaml: No such file or directory (os error 2)
- Unable to generate spritesheet
- [Feat]Can you support OGC's WFS, or do you have any recommended options for Martin's use?
- Loading sprites is very slow with big SVG HOT 3
- If sprites are in k8s configMap, image names get garbled
- Re-scan of MBTiles directory after adding new files HOT 1
- Add png-image support when generating sprite
- Even distributed features
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.